This content has been marked as final.
Show 3 replies
-
Re: SWQL, EOC and Select commands
jblankjblankAug 13, 2019 11:16 AM (in response to tmcurry)
Ill take a look and get back to you tmcurry
-
Re: SWQL, EOC and Select commands
David SmithAug 13, 2019 11:28 AM (in response to tmcurry)
2 of 2 people found this helpfulThe query probably needs to look like this:
SELECT n.Caption, n.Description, n.Location, n.MachineType, n.Status, p.City, p.AssetTag, p.Device_Function, p.SerialNumber, p.Network_Zone, p.Number_of_Physical_Devices, '1' AS [TotalResourceUnit], i.ObjectSubType p.Resource_Unit_Name FROM Orion.Nodes n INNER JOIN Orion.NodesCustomProperties p ON p.NodeID = n.NodeID INNER JOIN Orion.NPM.Interfaces i ON i.NodeID = n.NodeID
-
Re: SWQL, EOC and Select commands
tmcurry Aug 13, 2019 12:02 PM (in response to David Smith)That did the trick Thank you
-