[cisco-voip] Controlled devices

[Anthony Holloway]

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.

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:

[image: Inline image 1]

Speaking of making things bigger in the CUCM UI, these day of week lists
could stand to be bigger by default:
[image: Inline image 3]

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.

run sql select d.name as devicename, d.description, u.name 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 d.name = 'SEP0000DEAD0000'

Just replace the fake device name above with your target device name.

On Mon Feb 09 2015 at 11:19:48 AM Brian Meade <bmeade90 at vt.edu> wrote:

> Are you trying to use an API to pull the information?
>
> 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.
>
> On Mon, Feb 9, 2015 at 11:55 AM, TG <techguy.ca at gmail.com> wrote:
>
>>  Hi,
>>
>> Is there a way to get a list of controlled devices for an application
>> user?
>>
>> Thanks,
>> TG
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150209/87217a7f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 96811 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150209/87217a7f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 49996 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150209/87217a7f/attachment-0001.png>