1 Reply Latest reply on Dec 12, 2016 4:10 PM by CourtesyIT

    Report Writer - Adding fields from other Orion Database Sections

    CourtesyIT

      All,

       

      I am trying to create an active Dashboard and a report to include the following items.  Having an issue trying to add the APM_HardwareAlertData.ServiceTag AS Serial Number portion.  I would like to get the serial number of the device in the report.

      ////////////////////////////////////////////////////////////////////////////////////////////

       

      SELECT

      Nodes.Caption AS Node_Name,

      Nodes.IP_Address AS IP_Address,

      Nodes.Vendor AS Vendor,

      Nodes.MachineType AS Machine_Type,

      APM_HardwareAlertData.ServiceTag AS Serial_Number,

      Nodes.L1_Region AS L1_Region,

      Nodes.L2_SubRegion AS L2_SubRegion

      FROM

      Nodes

      WHERE

      (

          (Nodes.L1_Region = '1X1') AND

             (

                (Nodes.C3_Server_Function = 'Switch') OR

                (Nodes.C3_Server_Function = 'Router')

             )

      )

      ORDER BY 1

       

      /////////////////////////////////////////////////////////////////////////////////////////////////////

       

      Thanks,