CUCM 12.5 SQL Query for Device Creation (DateTimeStamp)

[Joel Jones]

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?

[Roger Kallberg]

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.

[Joel Jones]

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.