Adding Additional Lines Using SWQL

Question

Hey,

I have a question and was wondering if I could get some guidance. I'm in the process of trying to create a new dashboard (Classic). I tried breaking each column by Device Type (Server, Network, Storage, Hardware Health Overview). I went into edit on each column and tried to some basic SWQL queries like "Vendor='windows' my question is though, how do I add additional code to grab multiple vendor types etc. Like I want to add like ESXI Hosts and the APC/UPS etc. Then my other question I noticed is not all the devices I currently have in our Hardware Health Overview graph isnt displaying everything -do I need like some sort of API? Let me know.

Thanks,

Ross

Radimar · Answer

Like this?

SELECT ['Cisco', 'Windows', 'Linux', 'VMware'].Caption, ['Cisco', 'Windows', 'Linux', 'VMware'].MachineType, ['Cisco', 'Windows', 'Linux', 'VMware'].IP, ['Cisco', 'Windows', 'Linux', 'VMware'].Vendor FROM Orion.Nodes ['Cisco', 'Windows', 'Linux', 'VMware'] where ['Cisco', 'Windows', 'Linux', 'VMware']

The interesting thing is even if I try to search by like Vendor='Linux' nothing even shows up

jm_sysadmin · Answer

Post what you have so far and what you want to add

I might try something like:

SELECT [NODES].Caption, [NODES].MachineType, [NODES].IP, [NODES].Vendor
FROM Orion.Nodes [NODES]
where [NODES].Vendor in ('Cisco', 'Windows', 'VMware Inc.')

And if you need a list of Vendors in use:

SELECT DISTINCT [NODES].Vendor
FROM Orion.Nodes [NODES]