This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

SWQL - exclude one Vendor from Report

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.