Re: [cisco-voip] Inactive Device Query?

2017-09-13 Thread Charles Goldsmith
ustom SQL reports we export our CDR into so I don’t think I’d be >> able to get it for my org unless I were to front it myself or find a >> considerable ROI to pull out of it. >> >> >> >> Ben Amick >> >> Unified Communications Analyst >> >>

Re: [cisco-voip] Inactive Device Query?

2017-09-13 Thread Anthony Holloway
gt; > > *From:* Charles Goldsmith [mailto:wo...@justfamily.org] > *Sent:* Tuesday, September 12, 2017 12:39 PM > *To:* Ben Amick > *Cc:* cisco-voip@puck.nether.net > *Subject:* Re: [cisco-voip] Inactive Device Query? > > > > Ben, you can glean this info via CDR if you arc

Re: [cisco-voip] Inactive Device Query?

2017-09-13 Thread Ryan Ratliff (rratliff)
It uses data from a db table called registrationdynamic. From what I recall this is only updated once per day (around midnight by default) so last registered will only get you to within a 24-hour period. To find the specific time the phone unregistered you have to go to the syslogs. As an examp

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Brian Meade
The RIS Database contains a LastActTimeStamp field which is when that device last registered in Epoch time. The problem is you have to cross-reference between nodes as a device may have last registered to the publisher 2 years ago but is currently registered to a subscriber node. The new feature

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Charles Goldsmith
7 12:39 PM > *To:* Ben Amick > *Cc:* cisco-voip@puck.nether.net > *Subject:* Re: [cisco-voip] Inactive Device Query? > > > > Ben, you can glean this info via CDR if you archive those, but not an easy > task. Variphy has a report to pull this type of info from CDR and is quit

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Ben Amick
Tuesday, September 12, 2017 11:56 AM To: cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net> Subject: [cisco-voip] Inactive Device Query? I haven’t seen it mentioned before, but I feel like it’s a common thing to go through an audit old phones in the environment, but other than looking throu

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Charles Goldsmith
t; > > *From:* cisco-voip [mailto:cisco-voip-boun...@puck.nether.net > ] *On Behalf Of *Ben Amick > *Sent:* Tuesday, September 12, 2017 11:56 AM > *To:* cisco-voip@puck.nether.net > *Subject:* [cisco-voip] Inactive Device Query? > > > > I haven’t seen it mentioned before, b

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Ben Amick
2vS9MGvkzbWoJmAW6RjWNR2kX4MkjY-loj-Ne5jWApvjBPqqb9EVjdwIqid40r3rjApYQg1TCpmYQg0eTYiN8SCUrf6Dk> From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Ben Amick Sent: Tuesday, September 12, 2017 11:56 AM To: cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Matthew Loraditch
t;https://plus.google.com/+Heliontechnologies/posts> From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Ben Amick Sent: Tuesday, September 12, 2017 11:56 AM To: cisco-voip@puck.nether.net Subject: [cisco-voip] Inactive Device Query? I haven't seen it mentioned before, but I fe

Re: [cisco-voip] Inactive Device Query?

2017-09-12 Thread Matthew Loraditch
t;https://plus.google.com/+Heliontechnologies/posts> From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Ben Amick Sent: Tuesday, September 12, 2017 11:56 AM To: cisco-voip@puck.nether.net Subject: [cisco-voip] Inactive Device Query? I haven't seen it mentioned before, but I fe

[cisco-voip] Inactive Device Query?

2017-09-12 Thread Ben Amick
I haven't seen it mentioned before, but I feel like it's a common thing to go through an audit old phones in the environment, but other than looking through lists of terminated users and cross referencing active users, I can't think of any good way to audit phones to see if they're alive anymore