<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>Yeah, I was thinking the same thing Wes. I'm just not sure what the person who requested the report is looking for. If they're looking for real-time reports, i.e. why can't I dial this number, then it's not useful. It might be a report they are hoping to help departments with with respect to phones that are not plugged in but they're still being billed for.<br><br>Not sure quite yet.<br><span><br><span name="x"></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>Cooking with unix is easy. You just sed it and forget it. <br> - LFJ (with apologies to Mr. Popeil)<br><span name="x"></span><br></span><br><hr id="zwchr"><b>From: </b>"Wes Sisk" <wsisk@cisco.com><br><b>To: </b>"Lelio Fulgenzi" <lelio@uoguelph.ca><br><b>Cc: </b>"Jason Burns" <burns.jason@gmail.com>, cisco-voip@puck.nether.net<br><b>Sent: </b>Monday, April 25, 2011 11:03:40 AM<br><b>Subject: </b>Re: [cisco-voip] SQL database dips on v7 (how to get list of phones that are not plugged in)<br><br>
All RIS info is available though the AXL Servieabilty API.<br>
<br>
Stepping back there seems a simpler approach to me.<br>
1. use 'show risdb query' from CLI - this queries the local RIS
information on each server. run this on all servers. You can get
up to 1 record per phone from each server.<br>
2. Devices that have not registered will either not appear in the
RIS results or will appear with status unknown.<br>
3. mashup that data with an export of all phones<br>
<br>
Any phone which has not seen a registration status change on at
least 1 CM node would potentially be a phone that is not plugged in.<br>
<br>
You many even be able to abbreviate this with an RTMT device
search. I would take this approach with caution. When last I
checked RTMT would show a discrete row for every reported phone (1
phone, 3 nodes, = 3 rows) so this could produce false positives.
It's a pretty simple exercise in working with sets to do otherwise.<br>
<br>
Regards,<br>
Wes<br>
<br>
On 4/25/2011 10:49 AM, Lelio Fulgenzi wrote:
<blockquote cite="mid:1949592544.341713.1303742977009.JavaMail.root@simcoe.cs.uoguelph.ca">
<style>p { margin: 0; }</style>
<div style="font-family: Verdana; font-size: 10pt; color: rgb(0, 0, 0);">Thanks Jason. It doesn't look like there will be an easy
way to do this. RIS seems to keep information only about phones
that are plugged in. I'd have to some how export data from the
phone query off all servers and compare this to data that is
available for all phones.<br>
<span><br>
<span></span>---<br>
Lelio Fulgenzi, B.A.<br>
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario
N1G 2W1<br>
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>
Cooking with unix is easy. You just sed it and forget it. <br>
- LFJ (with apologies to Mr.
Popeil)<br>
<span></span><br>
</span><br>
<hr id="zwchr"><b>From: </b>"Jason Burns"
<a class="moz-txt-link-rfc2396E" href="mailto:burns.jason@gmail.com" target="_blank"><burns.jason@gmail.com></a><br>
<b>To: </b>"Lelio Fulgenzi" <a class="moz-txt-link-rfc2396E" href="mailto:lelio@uoguelph.ca" target="_blank"><lelio@uoguelph.ca></a><br>
<b>Cc: </b><a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Sent: </b>Monday, April 25, 2011 10:41:39 AM<br>
<b>Subject: </b>Re: [cisco-voip] SQL database dips on v7 (how
to get list of phones that are not plugged in)<br>
<br>
Lelio,<br>
<br>
The registration status is not actually stored in the Informix
database that I'm aware of. This means any SQL statement against
the database wouldn't yield the information you're looking for.<br>
<br>
The information about registration status is stored in a shared
memory space that the RIS process has access to. You can peek at
the information RIS has from the command line for each server
with the CLI command:<br>
<br>
show risdb query phone<br>
<br>
Where I think you need to go next is looking into another
interface to access the registration info. It may be possible to
query RIS programatically through the RIS web interface (just
like RTMT does), or there may be something in the AXL API for
this. I don't know the exact how-to for either of those though.<br>
<br>
-Burns<br>
<br>
<br>
<div class="gmail_quote">On Mon, Apr 25, 2011 at 10:23 AM, Lelio
Fulgenzi <span dir="ltr"><<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<div style="font-family: Verdana; font-size: 10pt; color: rgb(0, 0, 0);"><span><br>
I'm hoping to get information from the tables using
SQL and will read up on the database library in a
while, however, just wondering about this one. From
what I recall, IP address information is a different
characteristic. Is this store in tables at all? If
so/not, how can I access this information to produce a
snapshot of phones that are not plugged in?<br>
<br>
<br>
<br>
<span></span>---<br>
Lelio Fulgenzi, B.A.<br>
Senior Analyst (CCS) * University of Guelph * Guelph,
Ontario N1G 2W1<br>
<a href="tel:%28519%29%20824-4120" target="_blank">(519)
824-4120</a> x56354 <a href="tel:%28519%29%20767-1060" target="_blank">(519)
767-1060</a> FAX (JNHN)<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>
Cooking with unix is easy. You just sed it and forget
it. <br>
- LFJ (with apologies to
Mr. Popeil)<br>
<span></span><br>
</span><br>
</div>
</div>
<br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<pre><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</div></body></html>