[cisco-voip] CUCM 5.1.X - timestamps in informix database

[Wes Sisk]

Hidden column in every table called cdrtime shows the last 
update/modified time.  For example:
admin:run sql select first 1 name,cdrtime from device
name  cdrtime   
===== ==========
MTP_2 1202659026

http://www.onlineconversion.com/unix_time.htm
1202659026 = Sun, 10 Feb 2008 15:57:06 GMT

/Wes


Thorsten.Mayr at barclayscapital.com wrote:
> I am looking for a specific timestamp for a change in the database. I am
> trying to proof that the pkid's of a phone button template somehow
> switched (morphed). 
>
> Running something like this in CLI:
>
> admin:run sql select * from phonetemplate
>
> will return a whole lot of information on all phone button templates
> including a versiontimestamp which looks like something like this:
> 1207559703-aa30ae9e-c47b-4ad1-9090-80051854cee9
>
> Is there a way to decode this into a time stamp and what would that time
> stamp be?
> Last change, last query from a phone... we have 6 divided hex codes up
> there....
> Or is there a nice and easy table holding references with proper dates?
>
> The name implies that there is a mechanism of crosschecks, no?
>
> If anybody would have any ideas...
>
> Thanks
> T
>
> _______________________________________________
>
> This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered offi!
>  ce at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
> _______________________________________________
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>