[cisco-voip] Date in service?

[Wes Sisk]

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/e5f6f523/attachment.html>