1 Reply Latest reply on Sep 1, 2009 6:13 PM by HemiTruck

    Urgent help with sql

    valdemirs

      Please, tell me how create a report showing all data from a specified server (using sql queries)

      I'm issuing these:

      select * from nodes where (nodename='my_linux');

      but I'm getting strange output.

      I need all fields from a record (node details, volumes, interfaces, poller , etc).

      Thanks

        • Re: Urgent help with sql
          HemiTruck

          your select is only going to get data from the nodes table.  You will need a much broader statement to grab all the info you are looking for with unions on the node id to span all the tables.  As it is all you will get is data from the nodes table.