<html><body bgcolor="#FFFFFF"><div>It doesn't help now. But I've seen people put this sort of info in the description field.</div><div><br></div><div>It would be nice to have a few custom fields in the database for this sort of thing.<br>
<br>Sent from my iPhone</div><div><br>On 04/06/2010, at 2:01, Ryan Ratliff <<a href="mailto:rratliff@cisco.com">rratliff@cisco.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>Thanks Wes, I've confirmed that cdrtime is updated when the device table entry is modified so this won't for Lisa's needs.<div>
<br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div>
-Ryan</div></span>
</div>
<br><div><div>On Jun 3, 2010, at 1:54 PM, Wes Sisk wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<div bgcolor="#ffffff" text="#000000">
I believe cdrtime also gets updated any time a row is modified. I
cannot find a complete definition in IBM docs so far.<br>
<br>
I'm not aware of any way to identify when a phone was initially
provisioned in CM.<br>
<br>
/Wes<br>
<br>
On Thursday, June 03, 2010 10:40:59 AM, Ryan Ratliff
<a class="moz-txt-link-rfc2396E" href="mailto:rratliff@cisco.com"><<a href="mailto:rratliff@cisco.com">rratliff@cisco.com</a>></a> wrote:<br>
<blockquote cite="mid:2C5C3659-0F40-4A99-A8F4-FE9121301DFF@cisco.com" type="cite">Then the exact query I ran will get you what you want,
except if you have a lot of phones you need to run the query via AXL
since there is no limitation of data you can get via CLI sql query, and
it can cause problems if you do a really huge query.
<div><br>
<div><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; ">
<div>-Ryan</div>
</span></div>
<br>
<div>
<div>On Jun 3, 2010, at 10:18 AM, Lisa Notarianni wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div bgcolor="#ffffff" text="#000000">Ryan,<br>
<br>
Thanks for the info.<br>
<br>
I am trying to get a list of phones and how long they are in service -
all phones though.<br>
<br>
Ryan Ratliff wrote:
<blockquote cite="mid:86795031-EE37-4820-B2F3-D136531B5989@cisco.com" type="cite">
<pre>admin:run sql select name,cdrtime from device where name like 'SEP%'
name cdrtime
=============== ==========
SEP000B46BDDB7D 1269973046
In your case change 'SEP%' to the actual device name you want to search on.
Then convert the cdrtime value from epoch to a more readable format (<a class="moz-txt-link-freetext" href="http://www.onlineconversion.com/unix_time.htm"><a href="http://www.onlineconversion.com/unix_time.htm">http://www.onlineconversion.com/unix_time.htm</a></a>).
-Ryan
On Jun 3, 2010, at 9:43 AM, Lisa Notarianni wrote:
</pre>
<blockquote type="cite">
<pre>Is there any way to see what the original date was that a phone was added to Call Manager (ver 7.1.2.20000-2)?
--
<LNsignature.jpg>
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net"><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip"><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></a>
</pre>
</blockquote>
<pre>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<span><LNsignature.jpg></span></div>
</div>
</blockquote>
</div>
<br>
</div>
<pre><hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net"><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip"><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div><br></div></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>cisco-voip mailing list</span><br><span><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></span><br>
<span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br></div></blockquote></body></html>