[cisco-voip] Database callmanager 5.x

Wes Sisk wsisk at cisco.com
Wed Jul 2 10:58:32 EDT 2008


pkid is of type GUID, but as you  found, unfortunately informix GUID 
doesn't clearly contain timestamp as microsft SQL server GUID does.

that was my only idea for creation time.

/wes

Thorsten.Mayr at barclayscapital.com wrote:
> That'd be more then good enough.
> GUID... Hm, can't select it as a column and I assume 
>
> guid != pkid 
>
> (at least not obvious to me pkid doesn't seem to contain a
> (unix)timestamp)
>
> Sorry if thick question - where could I retrieve the GUID from?
> Also what's the determination of why some rows/entries were given have a
> versionstamp and some don't?
>
> The closest match to guid I was able to find was guidtable from the
> output of the syscolumns but that's probably the wrong direction...
>
> Thanks in advance
>
> T
>
>   
>> -----Original Message-----
>> From: Wes Sisk [mailto:wsisk at cisco.com] 
>> Sent: Wednesday, July 02, 2008 2:01 PM
>> To: Mayr, Thorsten: IT (LDN)
>> Cc: cisco-voip at puck.nether.net
>> Subject: Re: [cisco-voip] Database callmanager 5.x
>>
>> 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 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/afc9631b/attachment.html>


More information about the cisco-voip mailing list