[cisco-voip] Determining the Last time a sccp device was registered CCM 4.1.3

[Mike Lydick]

Thanks Wes, exactly what I was looking for, attaching epoch formula to tie
it to this thread.

=(((E2-(6*3600))/86400)+25569)

Best Regards,

Mike Lydick




On Fri, Aug 20, 2010 at 11:53 AM, Wes Sisk <wsisk at cisco.com> wrote:

>  covered several times on the list but easy enough:
> from the command line:
> mmfspy a
>
> run on each server.  'regchgti' is registration change time, reflects the
> last time CM processed registration for that device.  This is flushed after
> CM service restart and after RIS timeout as determined by RIS service
> parameters.
>
> /Wes
>
>
> On Friday, August 20, 2010 11:19:49 AM, Mike Lydick
> <mike.lydick at gmail.com> <mike.lydick at gmail.com> wrote:
>
> Is it possible to determine when a device was last registered with
> callmanager, or determine if it has been registered in the last 30/60 days?
> Maybe a sql query?
>
> Best Regards,
>
> Mike Lydick
>
>
>  ------------------------------
>
> _______________________________________________
> cisco-voip mailing listcisco-voip at puck.nether.nethttps://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100820/c2414686/attachment.html>