[cisco-voip] Date in service?

[Ryan Ratliff]

Thanks Wes, I've confirmed that cdrtime is updated when the device table entry is modified so this won't for Lisa's needs.

-Ryan

On Jun 3, 2010, at 1:54 PM, Wes Sisk wrote:

> I believe cdrtime also gets updated any time a row is modified.  I cannot find a complete definition in IBM docs so far.
> 
> I'm not aware of any way to identify when a phone was initially provisioned in CM.
> 
> /Wes
> 
> On Thursday, June 03, 2010 10:40:59 AM, Ryan Ratliff <rratliff at cisco.com> wrote:
>> 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>
>> 
>> 
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>   
> 

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