i am using the below sql query to fetch the asset details but i am not able to fetch - Software Version, Hardware, Node Category
SELECT n.NodeID, n.Unmanaged, n.Caption, n.IP_Address, n.Vendor, hi.servicetag 'SerialNumber', n.AssetType, n.SnowModelCategory, n.SupportTier 'Effective Support Tier', 'No' 'StackMember', n.Location, n.LocationName, n.Address, n.SysName 'System Name', n.MachineType 'MachineType'
FROM Nodes n left outer join APM_HardwareInfo hi on n.nodeid = hi.nodeid
UNION ALL
SELECT n.NodeID, n.Unmanaged, CONCAT(n.Caption, ' - ', ss.SerialNumber) 'Caption', n.IP_Address, Vendor, ss.Model 'MachineType', ss.SerialNumber, n.AssetType, n.SnowModelCategory, n.SupportTier 'Effective Support Tier', 'Yes' 'StackMember', n.Location, n.LocationName, n.Address, n.SysName
FROM (SELECT DISTINCT (SerialNumber), NodeID, Model FROM NPM_SwitchStackMember) ss
INNER JOIN (SELECT NodeID, Unmanaged, Caption, IP_Address, AssetType, SnowModelCategory, SupportTier, InventoryManagementTier, SnowManagementTier, vendor, machinetype, Location, LocationName, SysName, Address FROM Nodes) n
ON ss.NodeID=n.NodeID
ORDER BY Caption ASC
