11-28-2012 03:29 AM - edited 03-16-2019 02:26 PM
Hi,
Is there any way to track individual login/logouts of particular users in CUCM 8.6 ?
Cheers
John
11-28-2012 03:55 AM
Hi John,
Not sure if the following addresses your query:
The Cisco Extension Mobility and Cisco Extension Mobility Cross Cluster features keep a record of the devices to which users are actively logged in. For the Cisco Extension Mobility feature, the actively logged-in device report tracks the local phones that are actively logged in by local users; for the Cisco Extension Mobility Cross Cluster feature, the actively logged-in device report tracks the local phones that are actively logged in by remote users.
Cisco Unified Communications Manager provides a specific search window for searching for devices to which users are logged in. Follow these steps to search for a specific device or to list all devices for which users are actively logged in.
The Find and List Phones window displays. Records from an active (prior) query may also display in the window.
Note : To add additional search criteria, click the + button. When you add criteria, the system searches for a record that matches all criteria that you specify. To remove criteria, click the - button to remove the last added criterion or click the Clear Filter button to remove all added search criteria.
Note : To reverse the sort order, click the up or down arrow, if available, in the list header.
The window displays the item that you choose.
Regards,
Harmit.
09-07-2017 07:15 PM
Can you run the Actively Logged In Device Report from the CLI?
The other SQL query is interesting, but I just want the same data as the Actively Logged In Device Report.
Thanks
11-28-2012 03:59 AM
Thanks but that only displys the actively logged in users, I need an historical report on a particular user.
11-28-2012 04:01 AM
Hi,
You can this ldap query, and it will return user logged in time and login duration. The time is in epoch format, so you will need to ocnvert it to normal time. If you google epoch you will see links to where you can convert the time.
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 query below returned EM login for a single user
run sql select eu.userid, emd.logintime, emd.loginduration, emd.datetimestamp from extensionmobilitydynamic emd inner join enduser eu on emd.fkenduser_lastlogin=eu.pkid where (eu.userid='avi.uri')
userid logintime loginduration datetimestamp
=========== ========== ============= =============
avi.uri 1349943827 0 1349943826
from the below website, the longintime coverts to
11 Oct 2012 08:23:47 UTC
http://www.epochconverter.com/
Please rate all useful posts
"'Nature is too thin a screen, the glory of the omnipresent God bursts through it everywhere"-Ralph Waldo Emerson
12-03-2012 02:08 AM
Hi,
This may sound stupid, but where do i run this command?
12-04-2012 11:21 PM
This may sound stupid, but where do i run this command?
On thee server command line. (either at the console or via SSH)
GTG
02-18-2013 10:52 AM
Description of loginduration from
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/8_6_1/datadictionary_861.pdf
Type: long (Null OK)
Default Value: NULL
Rule (RI-41):
Type: Validation (Insert/Update)
Rule Name: (obsolete) Device Login Duration Restriction
Description: Login Duration is only valid on devices supporting Extension Mobility
So you are not able to see login / Logout activity.
It is only possibly to see logon time.
/Johnny
01-15-2016 01:16 PM
very useful , is anyway I could run a command to see on a multiple uc capps cluster where we need to know how EM users are logged on at a time ?
anyway this is very useful
Sam
09-07-2017 07:17 PM
What is the SQL query to run the Actively Logged IN Device Report from the CLI?
11-28-2012 05:27 AM
I don't think CUCM records login/logout history in an easilly consumable fashion. (I'm sure it'll be in some of the CUCM logs, but extractng & parsing is left as an exercise for the reader )
I'd do it by changing the EM Service URL to point to my own web page, and use that web page to keep track of logins/logouts. (I.e. do it outside of CUCM)
GTG
07-31-2014 05:54 AM
Gordon I know this is super old but +5 man!
Yosh
09-27-2013 08:37 PM
Robertja,
I hope someone has answered your question by now, but this was a good question so I'll break it down a bit here to help out anyone else who may have the same or similar questions in the future.
As indicated previously, yes, you can see a user logging in and out of Extension Mobility / Extension Mobility Cross Cluster. To do so, follow this process:
I. Enable detailed traces on the cluster and gather the following logs / traces via the Real Time Monitoring Tool (RTMT) during the time period the user supposedly logged in / out: (1) Call Manager / CCM (for registration) (2) Tomcat and Tomcat Security (3) Extension Mobility (4) Extension Mobility Application. Make sure to download uncompressed logs or de-compress all the files after download them. You will need them for the next step.
II. Use "Notepad++" or something similar to search through the trace files for the User ID you are interested in. If the user has done anything related to extension mobility during the timeframe in question, it will show up in the traces. Example:
III. Here we see part of a request user "91934942" so we can infer that the user has initiated an EM / EMCC login request. Take note of "12347" as it is tracking this particular request along several lines of the log file. If you are interested in EMCC, take note of the "US-CUCM-CL4-SDC" as it the visiting cluster involved in this request and "253739" is also tracking this request.
2012-07-20 08:10:47,835 INFO [http-8443-33] EMServiceServlet - 124347 : 253739 : US-CUCM-CL4-SDC: processEmccRequest: Received EMCC Home Cluster Login Request for :91934942
IV. A few lines down in the trace file we see the message below. We determined that "124347" is tracking this request, so we know that this message is relevant to our user. More importantly, we see the phone the user is trying to log in with "deviceName: SEPAA187AA9F919" which will give us information like device pool, device profile, SURL subscription status, etc. Also note "2012-07-20 08:10:47,871" which gives us the time this event occurred, down to the thousandth of a second. This is very useful when tracking issues across multiple nodes, or in the case of EMCC, multiple nodes.
2012-07-20 08:10:47,871 DEBUG [http-8443-33] EMServiceServlet - 124347: 253739: UC-EU-CL4-RBS: performHomeDeviceLogin for deviceName: SEPA4187529F204
V. If you are troubleshooting, watch out for the tracking number changing at different steps in the process. The line below identifies all of the tracking numbers (counters) that have been used thus far for this request. Notepad++ can highlight text, it is recommended that you highlight counters as they will easily allow you to identify portions what output is relevant to the issue you are working on. It is recommended that you highlight anything that is UNIQUE to the issue you are working on, such as the User ID and Phone name. Tracing what is happening, whether it is an extension mobility login or a phone call requires patience and experience, but if you follow the steps laid out here you will eventually navigate through traces very quickly and gain a much better understanding of what is happening. If you find this too easy and want something more advanced, try looking through some SDL traces using the same process and you will gain an even better understanding of what is happening.
2012-07-20 08:10:48,661 INFO [http-8443-33] Counters - 124347: Counters -->124347,67277,9220,7707,33,0,0,40298,1419,0,1313,348,4019,-405,672
VI. So, using the logs in CUCM, you have not only confirmed that the user has attempted login but seen that you can follow process in the logs to pinpoint a failure very easily. The exceptional logging in Cisco's Collaboration suite is one of the things that really make it straightforward to troubleshoot. I hope this has helped you.
VII. Notes: (1) the term trace and log are used interchangeably. (2) While the examples I provided below are for Extension Mobility Cross Cluster (only trace examples I had on hand at the moment) the process will be very similar or identical for regular Extension Mobility as well (and for other CUCM traces). (3) I would also recommend reading up on the call flow of extension mobility if you are troubleshooting an issue, between the call flow and the traces you should be able to troubleshoot 90% of the issues you face. (4) If your employer or customer has a Cisco SMARTnet contract you can always open a low-priority case with Cisco TAC and asking them to assist you in identifying this information. If you get them the logs they ask you for you will not be disappointed, the engineers working for Cisco TAC are very skilled at what they do.
11-11-2014 12:49 PM
Hi John,
There is a solution for this. it is called ALM PRO+.
ALM PRO+ allows companies to view ExtensionMobility usage and is able to run detailed reports for usage and management purposes.
Drop me a PM for more information
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