3 Replies Latest reply on Aug 13, 2019 12:02 PM by tmcurry

    SWQL, EOC and Select commands

    tmcurry

      Since we have the EOC2.2, we  are trying to convert some custom reports that we did in MS Reporting server to SWQL. We learned a few things.

      Custom properties do not appear in the nodes view when using the swql studio however that info does appear in Orion.NodesCustomProperties.

       

      So there are two things I am stuck on. However this post will cover the first one.

      select

          n.Caption,

          n.Description,

          n.Location,

          n.MachineType,

          n.Status,

          p.City,

          p.AssetTag,

          p.Device_Function,

          p.SerialNumber,

          p.Network_Zone,

          p.Number_of_Physical_Devices,

        TotalResourceUnit = 1,

         i.ObjectSubType,

         p.Resource_Unit_Name

      From Orion.Nodes n

      inner JOIN Orion.NodesCustomProperties p on p.NodeID = n.NodeID

      inner JOIN Orion.NPM.Interfaces i on i.NodeID = n.NodeID

       

      This query fails!

      If I take:

        TotalResourceUnit = 1,

      out of the query it works.

       

      I realize SWQL is a readonly language.  I also realize  that   TotalResourceUnit = 1, is creating for a lack of a better term a column.  I need that column or the rest of the query for the report wont work.

      How can I make this TotalResourceUnit = 1 work?

       

      Thank you in advance!