Thanks Wes, exactly what I was looking for, attaching epoch formula to tie it to this thread.<div><br></div><div>=(((E2-(6*3600))/86400)+25569)</div><div><br clear="all">Best Regards,<br><br>Mike Lydick<br><br><br>
<br><br><div class="gmail_quote">On Fri, Aug 20, 2010 at 11:53 AM, Wes Sisk <span dir="ltr"><<a href="mailto:wsisk@cisco.com">wsisk@cisco.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#ffffff" text="#000000">
covered several times on the list but easy enough:<br>
from the command line:<br>
mmfspy a<br>
<br>
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.<br>
<br>
/Wes<div><div></div><div class="h5"><br>
<br>
On Friday, August 20, 2010 11:19:49 AM, Mike Lydick
<a href="mailto:mike.lydick@gmail.com" target="_blank"><mike.lydick@gmail.com></a> wrote:<br>
</div></div><blockquote type="cite"><div><div></div><div class="h5">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?
<div><br clear="all">
Best Regards,<br>
<br>
Mike Lydick<br>
<br>
<br>
</div>
</div></div><pre><hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div><br></div>