[cisco-voip] CUPS/CUPC last login?

[Dave Wolgast]

Thanks for the quick answer.

To make sure I have this correct, Cisco Unified Personal Communicator
(CUPC) login data is stored in the CUCM database under the
extensionmobilitydynamic table?

Thanks again!


On Fri, Apr 26, 2013 at 1:48 PM, Stephen Welsh
<stephen.welsh at unifiedfx.com>wrote:

>  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
>
>
>
>  On 26 Apr 2013, at 17:38, Dave Wolgast <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
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
> --
> Dave Wolgast
> Livonia, NY
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130426/2161953a/attachment.html>