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.