01-23-2012 09:38 AM - edited 03-16-2019 09:09 AM
Is there a way to retrieve the 'Extension Mobility Dynamic' record for a large list of UDPs? The intent is to generate a list of UDPs that haven't been used in some time, and flag them for removal - as well as being able to track which device a user is logging into. If there is a better process for finding these, I'll be happy to learn it.
CUCM 6.1 & up
Thanks,
Beau
Solved! Go to Solution.
01-23-2012 11:26 AM
Hi
From CLI:
run sql select dd.name as device,pd.name as loggedinudp,ce.userid as currentuser,le.userid as lastuser from extensionmobilitydynamic emd left join device dd on emd.fkdevice = dd.pkid left join device pd on emd.fkdevice_currentloginprofile = pd.pkid left join enduser le on emd.fkenduser_lastlogin = le.pkid left join enduser ce on emd.fkenduser = ce.pkid
Log the output to a text file using putty or whatever, then read it with Excel as a fixed column width file.
Be aware that this isn't a 'historical' table - it shows the last logged in user, and the current logged in user. That's alll...
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
01-23-2012 11:26 AM
Hi
From CLI:
run sql select dd.name as device,pd.name as loggedinudp,ce.userid as currentuser,le.userid as lastuser from extensionmobilitydynamic emd left join device dd on emd.fkdevice = dd.pkid left join device pd on emd.fkdevice_currentloginprofile = pd.pkid left join enduser le on emd.fkenduser_lastlogin = le.pkid left join enduser ce on emd.fkenduser = ce.pkid
Log the output to a text file using putty or whatever, then read it with Excel as a fixed column width file.
Be aware that this isn't a 'historical' table - it shows the last logged in user, and the current logged in user. That's alll...
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
01-23-2012 12:06 PM
Brilliant! Thank you Aaron. Just the output I was looking for.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: