<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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; 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 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 wrap="">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">http://www.onlineconversion.com/unix_time.htm</a>).
-Ryan
On Jun 3, 2010, at 9:43 AM, Lisa Notarianni wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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">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>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<span><LNsignature.jpg></span></div>
</div>
</blockquote></div><br></div></body></html>