12-06-2023 08:23 AM - edited 12-06-2023 08:24 AM
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?
12-06-2023 08:43 AM
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.
12-06-2023 08:54 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide