Using executeSQLQuery to find device IP address

Version 1
    This document was generated from CDN thread

    Created by: Michael Burkhard on 01-02-2012 03:36:14 PM
    I'm trying to use executeSQLQuery on Unified Communications Manager to retreive the details of an h323 Gateway.  I can find it in the 'device' table, along with most of its attributes in the other related tables. (h323device, devicepool, etc.)  However, I can't find what table(s) to join with to get the IP address of the device. 
     
    Can someone please point me to where the IP address is stored, and what the relationship is between this and the device table?
     
    Many thanks.
     
    Mike Burkhard

    Subject: RE: Using executeSQLQuery to find device IP address
    Replied by: Michael Burkhard on 10-02-2012 03:59:31 PM
    Just FYI - I'm still curious if this can be done using executeSQLQuery.  But for now, I'll be using selectCmDevice from RisPort instead.

    Subject: RE: Using executeSQLQuery to find device IP address
    Replied by: David Staudt on 10-02-2012 04:31:46 PM
    As you surmise, the IP address (as a piece of 'real-time' data) is not stored in the database, and so is not accessible via AXL/executeSqlQuery.  You will need to use Risport which queries the Realtime Information Service that stores the dynamic IP/registration.