Nodes Inventory and Listing their resources

Try this. 

SELECT 
     [Nodes].IPAddress
    ,[Nodes].ObjectSubType
    ,[Nodes].Caption
    ,[Nodes].StatusDescription
    ,[Nodes].Volumes.Caption AS [Volume]
    ,[Nodes].Volumes.StatusDescription AS [VolumeStatusDescription]
    ,[Nodes].Interfaces.Name AS [InterfaceName] 
    ,[Nodes].Interfaces.StatusDescription AS [InterfaceStatusDescription]
    ,[Nodes].Applications.DisplayName AS [ApplicationDisplayName]
    ,[Nodes].Applications.StatusDescription AS [ApplicationStatusDescription]    
    ,[Nodes].Applications.Components.Name AS [ComponentName]
    ,[Nodes].Applications.Components.StatusDescription AS [ComponentStatusDescription]
FROM Orion.Nodes
Where [Nodes].ObjectSubType LIKE '%WMI%' OR [Nodes].ObjectSubType LIKE '%AGENT%'  OR [Nodes].ObjectSubType LIKE '%SNMP%'
Order BY [Nodes].Caption ASC

Excellent and Thank You bobmarley

Hello, did this work?