1 Reply Latest reply on Nov 21, 2012 12:00 AM by JiriPsota

    SQL Query to pull Universal Poller Data

    smartd

      Does anyone have some sample SQL queries to pull UnDP data for a specific node? 

      Also, does anyone know how to query the IPAM database for nodes based on IP?

        • Re: SQL Query to pull Universal Poller Data
          JiriPsota

          You can try following:

          Create new report of appropriate type ("Current Status of Nodes, Interfaces, etc." for current UnDP data or "Historical-Custom Pollers" for historical data). Select Fields you are looking for. Now in Report menu select "Show SQL" and check the SQL query in SQL tab. The same steps can be used also for other tables if you are not sure about the tables, columns and the bindings.

           

          The result for Custom node poller current status looks like:

          SELECT

          CustomNodePollerStatus_CustomPollerStatus.Status AS Status, Nodes.NodeID AS NodeID

          FROM

          (Nodes INNER JOIN CustomPollerAssignment CustomNodePollerAssignment_CustomPollerAssignment ON (Nodes.NodeID = CustomNodePollerAssignment_CustomPollerAssignment.NodeID))  INNER JOIN CustomPollerStatus CustomNodePollerStatus_CustomPollerStatus ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerAssignmentID = CustomNodePollerStatus_CustomPollerStatus.CustomPollerAssignmentID)

          WHERE

          (

          (CustomNodePollerAssignment_CustomPollerAssignment.InterfaceID = 0)

          )