Can anyone explain “last active” and “last registered”

[chuck47172]

Cisco Unified CM Administration

System version: 12.5.1.13900-152

Can anyone explain “last active” and “last registered” on call manager, Find and List Phones page?

It’s my understanding that “last active” displays the timestamp when a device was last actively involved in a call.

However, I never see that timestamp update when I make test calls to or from the device.

Last registered always says “NOW”. Never changes.

[stuartschwarzman]

This is quoted directly from CUCM

• Status—Displays the status of the phones. It can be: Registered, Unregistered, or None. A phone will be unregistered if the device was configured once but never seen on the network. If the phone is unregistered and then the Unified Communications cluster is rebooted, the phone moves to the None or Unknown state if the record status has timed out or the phone was reset (it can be from Cisco Unified CM Administration interface or BAT).

  Non-Jabber devices or phones do not display the registered status immediately after registration. The registration status is updated and displayed only after a scheduled DB Maintenance window if the device is registered at that time.

  For Cisco Jabber devices, the Device Registration Status, LastActive, LastRegistered details are updated when Jabber is registered with Unified Communications Manager, and after exchanging 3 KeepAlive messages. If Jabber devices are not registered during DB Maintenance window time, the registration status is updated only when it is registered with Unified Communications Manager and exchanged at least 3 or more times KeepAlive messages.

• Last Registered—The status is Now if the phone has registered within the last 10 days. Else, the status displays Never if the phone has never registered to the database until time.

• Last Active—This field updates the last time as to when the phone was active (onhook/offhook activity) and not the last registered time.

[stuartschwarzman]

chuck47172 --  My cluster acts the same way yours does as it does not update the "Last Active" field after a call is made.  Maybe someone can explain why.  Just know yours is doing the same thing my cluster is doing in regards to "Last Active".

[chuck47172]

Thanks for the info. Any idea why the “last active” never updates when I make test calls to or from the device?

[SteveK066]

Same with mine. Not a big deal, it would be good to know. I no longer reference the 'Last Active' date/time as a true indicator when the phone was last in use.

[Andy K MTL]

Hello, for the Last Active, I guess to save on server ressources it doesnt update RIGHT away,  on phones we have at work, it seems to update every 10 to 12 hours,  but after a day you see the real timestamp it was used.

It helps us to cleanup unused phones, if it has very old timestamps we know the phone isnt used much and could be removed!

My version is 12.5.1

[SteveK066]

So noted, I will look later or the next day after noting the last time I used the phone. It could be useful as stated to find phones that are seldomly used, or not used for quite some time. Departments with budget cuts may want to remove such phones!

[SteveK066]

@Andy K MTL - as you mentioned, the information will update 10+ hours later. I noted the date/time my phone was 'Last Active' - and it was in fact at the last time I used it yesterday afternoon. 

[RededorTI]

How to list phone in CUCM with "Never" status in the Last Registered

[stuartschwarzman]

@reder I'm not sure there is an easy way to filter on "Never".  The only items that you can filter on are listed below and "Never" isn't one of the items.  You could cut and paste your devices into a spreadsheet and filter from within the spreadsheet.

The items that you can filter on are listed below:

If I had to guess there is probably a way to get this information from the command line, but I'll have to let someone else answer that.

[chuck47172]

You can't filter on that which is idiotic in my opinion.

Here's what I do. 

Navigate to Device > Phone > Find. Leave the search field blank and click on FIND.

That will display 25 rows. What you want to do is to display all devices (rows). Cisco doesn't give you an easy way to do that either.

Note the total number of records found in the resulting status box at the top of the page.

Next change the value in the "rows per page" drop down box to 250 and click FIND.

After it displays 250 devices, take a look at the address bar in your browser.

In the address you will see...<server name >/ccmadmin/phoneFindList.do?lookup=false&multiple=true&rowsPerPage=250&pageNumber=1

Change the 250 value to total number of records found and hit enter.

Example, I have 6910 records that I want to display all at once so I modify the address to be 6910&pageNumber=1

This can take several minutes to load on the screen. Be patient, and all devices will appear on the same page.

Once all records are shown, press Ctrl A to select all text on the screen.

Then press Ctrl C to copy all the text.

Then paste all of that as text to an Excel spreadsheet.

You will need to clean up the spreadsheet somewhat and then you will see all the data in columns that you can sort on any of the column headings.
It's beyond me as to why Cisco hasn't made this easier. Maybe they will in a later release.

[stuartschwarzman]

@chuck47172 We lost the ability to enter the number of records, as you show, at least one version ago.  We are on version 12.5.1 .  I'm curious what version you are on?  The ability to show all your records by adjusting the address is definitely helpful.

[chuck47172]

I'm on CUCM System version: 12.5.1.13900-152
Works like a champ for me using Google Chrome Version 131.0.6778.109

[Maren Mahoney]

You can get a list of phones in the "Never" status using RTMT. I explain how here:

Post:  "List phone CUCM with "Never" status in the Last Registered"
https://community.cisco.com/t5/ip-telephony-and-phones/list-phone-cucm-with-quot-never-quot-status-in-the-last/m-p/5234472#M417864

Maren

(And I agree that's it's dumb that we can search on Status in CUCM directly.)