10-08-2013 01:43 AM - edited 03-16-2019 07:46 PM
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
10-08-2013 01:50 AM
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
10-08-2013 01:56 AM
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"
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide