1 Reply Latest reply on Mar 9, 2018 7:22 AM by David Smith

    SWQL - exclude one Vendor from Report

    joaohribeiro

      Hi All,

       

      I have the following SWQL query to check backed up vs not backed up devices:

       

      select distinct

      CASE

                                WHEN ConfigTable.NodeID IS NOT NULL  THEN 'backedUp'

                                   ELSE 'notBackedUp'

                                END as NCMNodeStatus,

                                    Orion.NodeID as CoreNodeID,               

                                    Orion.Caption,                

                                    ConfigTable.NodeID,

                                    Orion.IPAddress,

                                    Orion.DetailsUrl,

                                    Orion.ChildStatus,

                                    Orion.Vendor,

                                    Orion.Status,

                                    Orion.Icon,

                                    OrionVendors.Icon

      FROM Cirrus.NodeProperties as NCMNodeProperties

               join Orion.Nodes as Orion on Orion.NodeID=NCMNodeProperties.CoreNodeId

               join Orion.NodesCustomProperties as OrionCustomProperties on Orion.NodeId= OrionCustomProperties.NodeId

           INNER JOIN Orion.Vendors AS OrionVendors ON Orion.Vendor=OrionVendors.Name

               left join

               (

                  select NodeID from Cirrus.ConfigArchive

               ) as ConfigTable

              

               on NCMNodeProperties.NodeID=ConfigTable.NodeID      

              order by Orion.Caption ASC

       

      Could you please tell me how can i exclude one Vendor From Appearing on this List?
      Thanks in advance.