[cisco-voip] Database callmanager 5.x

[Wes Sisk]

unfortunately not.  the closest would be to derrive the timestamp from 
the GUID.
GUID is unique for every row in a table and timestamp is part of the 
GUID.  given the GUID is only generated when the row is inserted....

/wes

Thorsten.Mayr at barclayscapital.com wrote:
> Wes,
>
> CDRTIME = last touch
> Is there a hidden column for creation time as well by any chance? ;)
>
> Thanks
> T
>
>   
>> -----Original Message-----
>> From: Wes Sisk [mailto:wsisk at cisco.com] 
>> Sent: Tuesday, July 01, 2008 6:44 PM
>> To: Mayr, Thorsten: IT (LDN)
>> Subject: Re: [cisco-voip] Database callmanager 5.x
>>
>> welcome. wasn't avoiding you, just wanted to get correct 
>> answer out for all. /wes
>>
>> Thorsten.Mayr at barclayscapital.com wrote: 
>>
>> 	Thanks Wes 
>> 	
>> 	  
>>
>> 		-----Original Message-----
>> 		From: Wes Sisk [mailto:wsisk at cisco.com] 
>> 		Sent: Tuesday, July 01, 2008 5:36 PM
>> 		To: Mayr, Thorsten: IT (LDN)
>> 		Cc: cisco-voip at puck.nether.net
>> 		Subject: Re: [cisco-voip] Database callmanager 5.x
>> 		
>> 		correction: numplan.  short circuit between 
>> keyboard and monitor
>> 		
>> 		admin:run sql select * from typepatternusage
>> 		enum name               moniker
>> 		==== ================== ==========================
>> 		0    CallPark           PATTERN_CALL_PARK
>> 		1    Conference         PATTERN_CONF
>> 		2    Device             PATTERN_DEVICE
>> 		3    Translation        PATTERN_TRANSLATION
>> 		4    Call Pick Up Group PATTERN_CALL_PICK_UP_GROUP
>> 		5    Route              PATTERN_ROUTE
>> 		6    Message Waiting    PATTERN_MESSAGE_WAITING
>> 		7    Hunt Pilot         PATTERN_HUNT_PILOT
>> 		8    Voice Mail Port    PATTERN_VOICE_MAIL_PORT
>> 		9    Domain Routing     PATTERN_ROUTE_DOMAIN
>> 		10   IPAddress Routing  PATTERN_ROUTE_IPNET
>> 		11   Device template    PATTERN_DEVICE_TEMPLATE
>> 		
>> 		admin:run sql select pkid,dnorpattern from 
>> numplan where 
>> 		tkpatternusage=5
>> 		
>> 		/Wes
>> 		
>> 		
>> 		Wes Sisk wrote:
>> 		    
>>
>> 			routeplan primarily.  CM 5.0 database 
>> dictionary:
>> 			
>> 			      
>>
>> 		
>> http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/5_0_4/dd50
>> 		    
>>
>> 			4.pdf
>> 			
>> 			
>> 			some interesting things change in 6 
>> with database user 
>> 			      
>>
>> 		facing features:
>> 		    
>> 		
>> http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_0_1/dd60
>> 		    
>>
>> 			1.pdf
>> 			
>> 			
>> 			/Wes
>> 			
>> 			Thorsten.Mayr at barclayscapital.com wrote:
>> 			      
>>
>> 				Guys,
>> 				
>> 				I am looking for the name of 
>> the table that would contain the 
>> 				routepatterns in the informix database.
>> 				
>> 				I did look at the systables etc 
>> but couldn't make it out. 
>> 				        
>>
>> 		If anybody 
>> 		    
>>
>> 				knows... much appreciated
>> 				
>> 				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
>> 				  
>> 				        
>>
>> 			
>> 			      
>>
>> 	_______________________________________________
>> 	
>> 	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 Barclay
>> 	s 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.
>> 	_______________________________________________
>> 	  
>>
>>
>>     
> _______________________________________________
>
> 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.
> _______________________________________________
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080702/4bb4cf17/attachment-0001.html>