[cisco-voip] Date in service?

[Ryan Ratliff]

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.

-Ryan

On Jun 3, 2010, at 10:18 AM, Lisa Notarianni wrote:

> Ryan,
> 
> Thanks for the info.
> 
> I am trying to get a list of phones and how long they are in service - all phones though.
> 
> Ryan Ratliff wrote:
>> 
>> 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 (http://www.onlineconversion.com/unix_time.htm). 
>> 
>> -Ryan
>> 
>> On Jun 3, 2010, at 9:43 AM, Lisa Notarianni wrote:
>> 
>>   
>>> 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
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>     
>> 
>>   
> 
> -- 
> <LNsignature.jpg>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100603/fe85ff0a/attachment.html>