[cisco-voip] Extension Mobility Report

[Bernhard Albler]

Hi all,

actually you can query the ccm for this info.
The following query gives you the last login time for a specific device, you could modify the query to query on the basis of users:
run sql select n.dnorpattern,d.name,p.name,em.datetimestamp,em.cdrtime from device d,device p,devicenumplanmap dnmp,numplan n,extensionmobilitydynamic em where em.fkdevice=d.pkid and em.fkdevice_currentloginprofile=p.pkid and p.pkid=dnmp.fkdevice and dnmp.fknumplan=n.pkid and d.name='SEP001122334455'

would give you something like this:
dnorpattern name            name             datetimestamp cdrtime
=========== =============== ================ ============= ==========
42052       SEP006440B57D82 UDP_jdoe_8961 1288356300    1288356300

Both the datetimestamp and the cdrtime (hidden field which shows last update of the row) are unix timestamps, so you probably want to convert this to something more user friendly or use stephens product.

kind regards
bernhard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101029/b51460bf/attachment.html>