Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Phone Last Registration

Phone Last Registration

Phone Last Registration


I'm trying to generate a list of the last registration times for all the phones.
I have tested the below on four different lab setups: CUCM 10.1, CUCM 12, CUCM 12.5 & CUCM 14 but get the same result.
I connected an IP communicator softphone to the CUCM. When I look at the phone list, I see that the phone status is Registered and the Last Registered is listed as now.
When I close the softphone, the Status is changed to Unregistered, however the Last Registered shows Never.

I tried to query the registration DB using the CLI:
run sql select d.name, r.* from registrationdynamic r join device d on r.fkdevice=d.pkid

but got the same result, i.e., no data about the last registration.

Any ideas on how to troubleshoot this?


RE: Phone Last Registration

I don't have experience with CLI in CUCM, but that would be a useful query.

I wonder what specifically does the Last Active column signify in CUCM Administration when looking at Device - Phone. The date and time are not the last time the phone was used.

RE: Phone Last Registration

Hi, i dont know if this is still something you are interested in but in our solution we have a device registration history feature. That means as default we get the status of each phone every 15 minutes. That means we have 96 entrys per device per day. You can adjust it to get it each 30 minutes or each hour, but thats up to you.

We did this feature because we wanted to know as engineer how many phones of which type was registered at a specific time. Also we wanted to have a option to show all phones which was not registred for X days. To keep your cucm clean its good to know if your Android or iPhone Jabbers are registered or are never :) Here you will also see how it looks like https://kb.easy-uc.com/kb/dashboard/phone-registra...

Just visit https://www.easy-uc.com to see the solution.

If you want to try it by your own, create an account in our portal https://portal.easy-uc.com . Download there OVA file and create demo license by your own and just test the solution.

At https://kb.easy-uc.com you will get a configuration guide how to setup the solution.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close