cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

AMA-CUCM Troubleshooting: Best Practices for Reading Trace Files

333
Views
15
Helpful
8
Replies
Beginner

Phone Device housekeeping (faulty)

Is there a way to generate list of phone not registered to CUCM? Im trying to do housekeeping for license related stuff. Right now the only way I can see is to sort/search device type and highlight copy/paste to excel sheet. Has anyone got better approach? Thank you.

Everyone's tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
VIP Collaborator

Re: Phone Device housekeeping (faulty)

In RTMT, go to Voice/Video > Device > Device Search. Do a search for Phones that are Device Only Configured in Database. This will list all phones in the "None" status. If you have CUCM 12.x, you can download this list but in earlier versions it is a view-only list. There might be a way to generate that data with a SQL query, but I don't know how to do that.

Maren

8 REPLIES 8
VIP Collaborator

Re: Phone Device housekeeping (faulty)

In RTMT, go to Voice/Video > Device > Device Search. Do a search for Phones that are Device Only Configured in Database. This will list all phones in the "None" status. If you have CUCM 12.x, you can download this list but in earlier versions it is a view-only list. There might be a way to generate that data with a SQL query, but I don't know how to do that.

Maren

Beginner

Re: Phone Device housekeeping (faulty)

Cool let me try that. Thank you.
Highlighted
VIP Collaborator

Re: Phone Device housekeeping (faulty)

I just reread your original post. If you go through that same search sequence, another option is to list all phones currently in "unregistered" status. Between that and the "None" list, you should have a more complete picture of anything not currently registered.

Maren

Beginner

Re: Phone Device housekeeping (faulty)

Hi Maren,

 

Forgot to mention that we are currently using v11.0 but so far I cant sort them to "unregistered" or I could be wrong? Could it be only applicable to higher version?

VIP Collaborator

Re: Phone Device housekeeping (faulty)

What I meant was that through a similar search in RTMT you can search for Unregistered phones.

Beginner

Re: Phone Device housekeeping (faulty)

I see. will check that. thanks!
VIP Advisor

Re: Phone Device housekeeping (faulty)

You cannot pull registration status from SQL, however, you can from the CLI command: show risdb query phone. The thing to know here though, is that you have to run this command on all CM nodes, and each CM node will have a different view of the phones. E.g., You have a phone which registers to Sub1, then you change its CMG and reset it, and now it's registered to Sub2. If you run the CLI command on both servers, Sub1 will report the phone as "unreg" while Sub2 will report "reg".

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
Beginner

Re: Phone Device housekeeping (faulty)

Thank you for the info.

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards