<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
unfortunately not. the closest would be to derrive the timestamp from
the GUID.<br>
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....<br>
<br>
/wes<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> wrote:
<blockquote
cite="mid:568BC086983B9544993FA5104CF68E1A030053C5@LDNPCMEU304VEUA.INTRANET.BARCAPINT.COM"
type="cite">
<pre wrap="">Wes,
CDRTIME = last touch
Is there a hidden column for creation time as well by any chance? ;)
Thanks
T
</pre>
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
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
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> wrote:
Thanks Wes
-----Original Message-----
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
Sent: Tuesday, July 01, 2008 5:36 PM
To: Mayr, Thorsten: IT (LDN)
Cc: <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
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:
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/5_0_4/dd50">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/5_0_4/dd50</a>
4.pdf
some interesting things change in 6
with database user
facing features:
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_0_1/dd60">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_0_1/dd60</a>
1.pdf
/Wes
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> 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:
<a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>. 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
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
_______________________________________________
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: <a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>. 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.
_______________________________________________
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
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: <a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>. 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.
_______________________________________________
</pre>
</blockquote>
</body>
</html>