Well if I got you correctly, you want to list the 500 oldest IP phones registered to the CUCM cluster as per their registration date. If this is correct, not sure what exactly your motto is and will you ever be able to get the true status since there is a huge possibility that phones during their life time had registered more than once and every time this will happen, the new date will go in the database. So to really get the oldest 500 IP Phones is next to impossible unless they have never been registered more than once which I really doubt in a long working environment but still you can do this:
Run the command show risdb query phone on every CM server in the cluster. After you got the list, look for RegStatusChg TimeStamp field and then use the below method using MS Excel to convert the time in a readable format:
1.Put the timestamp in cell a1.
2.In cell a2, enter =a1/86400+25569
3.To apply a new format to this cell, right-click and choose Format cells >
Numbers > Custom. In the Type field, enter m/d/yyyy h:mm
Regards
Deepak
- Rate Helpful Posts -
