<div dir="ltr">lol Anthony, you said it all, hence my request posted in here. These are some of the gaps between users and app-users which the newer releases should address. At least making it like end-users would even help.Haven't tested 10.x yet, wonder if anything changed in this aspect.</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 9, 2015 at 1:11 PM, Anthony Holloway <span dir="ltr"><<a href="mailto:avholloway+cisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Occam's Razor at it's finest Brian. Truthfully though, unless it's for an End User, I don't even bother looking at the list for an Application User; it's too long to effectively be managed in that little window. At least with End Users, there is a check box when searching for more phones which states "Show the devices already associated with user"; however, that does not exist for Application Users.<div><br></div><div>I know the list is sorted numerically (in Hex), but only if there was a way to make the list bigger in a service parameter:</div><div><br></div><div><img src="cid:ii_14b6f657482b2535" alt="Inline image 1" style="margin-right:0px" width="556" height="562"><br></div><div><br></div><div>Speaking of making things bigger in the CUCM UI, these day of week lists could stand to be bigger by default:</div><div><img src="cid:ii_14b6f70403f29558" alt="Inline image 3" width="562" height="396"><br></div><div><div><br></div><div>Another fun activity is finding all of the Application Users a particular device is controlled by. I found this useful in validating an Agent's phone which needed to be controlled by/monitored by more than one application. Here's the SQL query for that.</div><div><br></div><div>run sql select <a href="http://d.name" target="_blank">d.name</a> as devicename, d.description, <a href="http://u.name" target="_blank">u.name</a> as userid from applicationuserdevicemap as m left join applicationuser as u on m.fkapplicationuser = u.pkid left join device as d on m.fkdevice = d.pkid where <a href="http://d.name" target="_blank">d.name</a> = 'SEP0000DEAD0000'<br></div><div><br></div>Just replace the fake device name above with your target device name.<div><br><div class="gmail_quote"><span class="">On Mon Feb 09 2015 at 11:19:48 AM Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>> wrote:<br></span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class=""><div dir="ltr">Are you trying to use an API to pull the information?<div><br></div><div>If you don't need to use an API or want a SQL query, it's just listed on the application user page in CCMAdmin.</div></div></span><span class=""><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 9, 2015 at 11:55 AM, TG <span dir="ltr"><<a href="mailto:techguy.ca@gmail.com" target="_blank">techguy.ca@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<font size="-1">Hi,<br>
<br>
Is there a way to get a list of controlled devices for an
application user?<br>
<br>
Thanks,<br>
TG<br>
</font>
</div>
<br>______________________________<u></u><u></u>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/<u></u>mailma<u></u>n/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>
______________________________<u></u><u></u><u></u>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/<u></u>mailma<u></u><u></u>n/listinfo/cisco-voip</a><br>
</span></blockquote></div></div></div></div>
</blockquote></div><br></div>