cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
200
Views
2
Helpful
2
Replies

CUCM 12.5 SQL Query for Device Creation (DateTimeStamp)

Joel Jones
Level 1
Level 1

Does anyone know of a SQL Query that will provide us with a timestamp of when a device was created.

For example, you type in the device name of 'CSF123456789' it would spit out the timestamp (date and time) of when it was created?

2 Replies 2

As far as I know the database does not contain information about when a device was created. You can look for yourself what information that is in the CM DB. Search for “cucm database schema” in your favourite search engine.



Response Signature


Joel Jones
Level 1
Level 1

So yeah, I couldn't find anything in the Schema. But, then I thought to myself "What kind of developer would not want to include a timestamp for the creation date of anything in a database." It seems pretty neglectful to not have that information, so I had to ask the community to see if anyone has become creative in finding that information.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: