I have been pulling individual queries to create this report but I haven't found out how to make it into just 1 query. Can anyone assist?
Here are the queries I am using to get the info. Can you think of a way to simplify this into 1 process?
SELECT servername, Nodes, Elements, Interfaces, Volumes FROM [dbo].[Engines]
SELECT COUNT(*) AS ICMP FROM Nodes
Where EngineID = '8'
and ObjectSubType = 'icmp'
SELECT COUNT(*) AS SNMP FROM Nodes
Where EngineID = '8'
and ObjectSubType = 'snmp'
SELECT COUNT(*) AS WMI FROM Nodes
Where EngineID = '8'
and ObjectSubType = 'wmi'