[cisco-voip] timestamp end user created in the CUCM database

[Thorsten.Mayr at barclayscapital.com]

As an example:

admin:run sql select pkid,cdrtime  from callingsearchspace where pkid =
'386a6025-f4fd-9276-1d0d-efc43d1b8bc7' 
pkid                                			 cdrtime    
==================================== ========== 
386a6025-f4fd-9276-1d0d-efc43d1b8bc7		 1214620870  

or

admin:run sql select pkid,dnorpattern,cdrtime from numplan where
tkpatternusage=5 pkid 
                                dnorpattern
cdrtime    
==================================== ================== ========== 
aceb4695-b8f0-27c3-2969-a16c95c05073 900!         1197554336 
2e0ff1a5-f0b6-1292-faed-d042bf262616 999              1185961869 
<Deleted all the other ones>

It does change on changes I believe and not last touch as in last view.
However no creation date on this one (at least I wouldn't how/where...)
and I did spend quite a bit of time on this recently myself ):

Hope the above helps.


Cheers
T


> -----Original Message-----
> From: Mordechai [mailto:m.rabinovich at nves.ca] 
> Sent: Monday, July 14, 2008 4:40 PM
> To: Mayr, Thorsten: IT (LDN); cisco-voip at puck.nether.net
> Subject: RE: [cisco-voip] timestamp end user created in the 
> CUCM database
> 
> Yes, I remember now seeing the post from Wes. 
> 
> We are running 5.1.3 so I have to work with a hidden column. 
> Now what is a hidden column and how you select it? Is this 
> field changes for any change on a record?
> 
> Thanks!
> 
> Mord
> 
> -----Original Message-----
> From: Thorsten.Mayr at barclayscapital.com
> [mailto:Thorsten.Mayr at barclayscapital.com]
> Sent: Monday, July 14, 2008 9:46 AM
> To: m.rabinovich at nves.ca; cisco-voip at puck.nether.net
> Subject: RE: [cisco-voip] timestamp end user created in the 
> CUCM database
> 
> There was a post from Wes a few days ago.
> 
> In v. 4 (windows based) the guid contains a timestamp of the 
> creation date. Have a look through the archive for more 
> details or I can see if I still have his email somewhere.
> 
> On v.5.x unfortunately there only is a field for last touch 
> (cdrtime which is a hidden column) which is useful to check 
> for pwd changes e.g.
> (if not ldap integrated)
> 
> hth
> T 
> 
> PS: someone correct me if I mixed things up
> 
> > -----Original Message-----
> > From: cisco-voip-bounces at puck.nether.net
> > [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Mordechai
> > Sent: Monday, July 14, 2008 2:27 PM
> > To: cisco-voip at puck.nether.net
> > Subject: [cisco-voip] timestamp end user created in the 
> CUCM database
> > 
> > Hello,
> > 
> >  
> > 
> > Anybody knows if there is a way to check when a user was created in 
> > CCM?
> > 
> >  
> > 
> > Thanks!
> > 
> >  
> > 
> > Mord
> > 
> > 
> > No virus found in this outgoing message.
> > Checked by AVG.
> > Version: 7.5.524 / Virus Database: 270.4.10/1551 - Release
> > Date: 7/14/2008 6:49 AM
> > 
> > 
> > 
> _______________________________________________
> 
> 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 office at 1 Churchill Place, 
> London, E14 5HP.
> This email may relate to or be sent from other members of the 
> Barclays Group.
> _______________________________________________
> 
> No virus found in this incoming message.
> Checked by AVG. 
> Version: 7.5.524 / Virus Database: 270.4.10/1551 - Release 
> Date: 7/14/2008
> 6:49 AM
>  
> 
> No virus found in this outgoing message.
> Checked by AVG. 
> Version: 7.5.524 / Virus Database: 270.4.10/1551 - Release 
> Date: 7/14/2008
> 6:49 AM
>  
> 
> 
_______________________________________________

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 office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________