[cisco-voip] SQL database dips on v7 (how to get list of phones that are not plugged in)

[Wes Sisk]

All RIS info is available though the AXL Servieabilty API.

Stepping back there seems a simpler approach to me.
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.
2. Devices that have not registered will either not appear in the RIS 
results or will appear with status unknown.
3. mashup that data with an export of all phones

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.

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.

Regards,
Wes

On 4/25/2011 10:49 AM, Lelio Fulgenzi wrote:
> 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.
>
> ---
> Lelio Fulgenzi, B.A.
> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
> (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Cooking with unix is easy. You just sed it and forget it.
>                               - LFJ (with apologies to Mr. Popeil)
>
>
> ------------------------------------------------------------------------
> *From: *"Jason Burns" <burns.jason at gmail.com>
> *To: *"Lelio Fulgenzi" <lelio at uoguelph.ca>
> *Cc: *cisco-voip at puck.nether.net
> *Sent: *Monday, April 25, 2011 10:41:39 AM
> *Subject: *Re: [cisco-voip] SQL database dips on v7 (how to get list 
> of phones that are not plugged in)
>
> Lelio,
>
> 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.
>
> 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:
>
> show risdb query phone
>
> 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.
>
> -Burns
>
>
> On Mon, Apr 25, 2011 at 10:23 AM, Lelio Fulgenzi <lelio at uoguelph.ca 
> <mailto:lelio at uoguelph.ca>> wrote:
>
>
>     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?
>
>
>
>     ---
>     Lelio Fulgenzi, B.A.
>     Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
>     (519) 824-4120 <tel:%28519%29%20824-4120> x56354 (519) 767-1060
>     <tel:%28519%29%20767-1060> FAX (JNHN)
>     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>     Cooking with unix is easy. You just sed it and forget it.
>                                   - LFJ (with apologies to Mr. Popeil)
>
>
>
>     _______________________________________________
>     cisco-voip mailing list
>     cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
>     https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
> _______________________________________________
> 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/20110425/ca9e5638/attachment.html>