I have the following SWQL query to check backed up vs not backed up devices:
WHEN ConfigTable.NodeID IS NOT NULL THEN 'backedUp'
END as NCMNodeStatus,
Orion.NodeID as CoreNodeID,
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
select NodeID from Cirrus.ConfigArchive
) as ConfigTable
order by Orion.Caption ASC
Could you please tell me how can i exclude one Vendor From Appearing on this List?
Thanks in advance.