[cisco-voip] CUPS/CUPC last login?

[Stephen Welsh]

Hi Dave,

The "extensionmobilitydynamic" table holds that information, run the following from the UCM command line:

run sql SELECT eu.userid, DBINFO('utc_to_datetime', ed.logintime) AS logintime FROM extensionmobilitydynamic AS ed JOIN enduser AS eu ON ed.fkenduser = eu.pkid

An example looks like this:

userid logintime
================== =====================
stephen.welsh 2013-04-26 13:28:07.0
david.williams 2013-04-26 16:44:20.0

If you need to gather and export all that information, you will probably need to use something that interfaces with the AXL API on UCM, there is an AXL Plugin that has some sample code/application that you should be able to use.

However, I recommend you have a look at PhoneView from UnifiedFX (http://www.unifiedfx.com), one of it's many features is the ability to gather key information about each phone and it's logged in user including the above information. This can be exported to a spreadsheet for further investigation or reporting.

Thanks

Stephen Welsh
CTO

[cid:CBBF0493-235C-43D2-A874-9FB3D95AF598 at b2.unifiedfx.com]


On 26 Apr 2013, at 17:38, Dave Wolgast <dwolgas1 at rochester.rr.com<mailto:dwolgas1 at rochester.rr.com>>
 wrote:

Is there a query that can be run on either CUCM or the CUPS server that will list users with their last login time/date?

--
Dave Wolgast
Livonia, NY
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto: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/20130426/fa57850e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 1364 bytes
Desc: image003.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130426/fa57850e/attachment.png>