Exclude nodename contactain XXX from all down nodes

Question

Hi, Im trying to display all the node status in Moderndashboard and i need to exclude the printers from the list, usually all the printers contains PRN in the name , mostly in between Is there any way we can exclude any nodes which contains PRN in the Name 
 select count(1) as countnodes from orion.nodes where status <>1 
 Need to exclude any nodes which contains PRN in the name from the above list Any help is appreciated :-)

borgan · Accepted Answer

Try this in the SWQL query: 
 SELECT TOP 100 n.Caption, n.Status FROM Orion.Nodes n WHERE Caption Not LIKE '%PRN%'

Exclude nodename contactain XXX from all down nodes

Top Replies