cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2769
Views
5
Helpful
2
Replies

CUCM SQL to view Logged in Phones (extension mobility)

Marc Richter
Level 1
Level 1

Hi all,

is there any SQL statement, showing me all Phones where people are logged in with their extension? There is a function like this on Device - Phone scrolling down to Extension Information and there is a field called "Current Device Profile", but I'll need this with all phones in a specific device pool.

Anyone got an idea?

Thanks in advance

regards

Marc

2 Replies 2

m.batts
Level 4
Level 4

HI MArc,

whenever someone logs in the extensionmobilitydynamic table is updated.Here's a SQL command i use to list login times etc.This will least everyone i.e not by device pool but should give you enough to go on.

run sql select u.userid, d.name,v.name e.logintime device from extensionmobilitydynamic e

inner join enduser u on e.fkenduser = u.pkid

inner join device d on e.fkdevice = d.pkid

inner join device v on e.fkdevice_currentloginprofile = v.pkid

its been formatted for easier reading so needs to be entered as one long line of txt.

Cheers

Mark

Ayodeji Okanlawon
VIP Alumni
VIP Alumni

Marc,

run sql select eu.userid, emd.logintime, emd.loginduration, emd.datetimestamp from extensionmobilitydynamic emd inner join enduser eu on emd.fkenduser_lastlogin=eu.pkid

The dates I believe are in epoch format..so you need to convert them to normal time

Please rate all useful posts

"opportunity is a haughty goddess who waste no time with those who are unprepared"

Please rate all useful posts
Getting Started

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: