Get last login time and other information for CUCM users

Version 1
    This document was generated from CDN thread

    Created by: Mayank Sharma on 06-01-2009 07:05:35 PM
    Hi again,

    I am trying to figure out if CUCM saves the user activity data of users who have access to the CUCM interface, like the last login time, isLocked etc. It's hard to imagine that it doesn't.

    For example, say I am the Administrator and use user name "Administrator" to login to the web interface. Where is all the activity saved?

    I looked at the tables in the data dictionary document and coulnd't find any useful table.

    Is there a way I can pull this information and is it available in the CUCM interface itself?

    Thanks,
    Max

    Subject: Re: Get last login time and other information for CUCM users
    Replied by: David Staudt on 06-01-2009 10:27:24 PM
    No usage tracking is stored in the DB, but I understand some basic info is logged. Looking at the 'Cisco Role-based Security' log shows access, operation and PKID of the effected object:

    2008-08-20 16:07:38,654 INFO [http-8443-Processor24] utilities.MLA - /phoneServiceParameterSave: pkid/name b364c69e-573b-2c4d-95f5-fe129b04ab4c add successful , userid Administrator
    2008-08-20 16:07:57,554 INFO [http-8443-Processor25] utilities.MLA - /phoneServiceParameterSave: pkid/name ceea585e-7646-2ca4-8104-ca3a1a62fb27 add successful , userid Administrator
    2008-08-20 16:08:01,091 INFO [http-8443-Processor23] utilities.MLA - /phoneServiceParameterSave: pkid/name ceea585e-7646-2ca4-8104-ca3a1a62fb27&closewin=1 update successful , userid Administrator

    This info wouldn't be necessarily intended for programmatic use and is not documented (it's intended for troubleshooting), but you may find it useful.

    Subject: Re: Get last login time and other information for CUCM users
    Replied by: Mayank Sharma on 07-01-2009 01:18:07 PM
    Thanks David. It's you again

    This looks like some useful information. How (or rather where) do I access these logs?

    Thanks,
    Max

    Subject: Re: Get last login time and other information for CUCM users
    Replied by: David Staudt on 08-01-2009 09:19:22 PM
    I grabbed this log using the Real Time Monitoring Tool (RTMT) plugin, downloable from the CUCM Admin web UI.

    Likely using the Serviceability SOAP API's Log Collection Service, you could retrieve the log files via your application.

    Subject: Re: Get last login time and other information for CUCM users
    Replied by: Mayank Sharma on 09-01-2009 01:05:49 PM
    Oh! Thanks .