Error while running a Query

bjvariya

Dear Thwack

While I run a query mentioned below to fetch Inventory report for nodes, I am facing an error as per below screenshot, please note other queries run successfully.

and I have also updated SWQL config file for operation time out to 15 mins.

SELECT N.NodeName, N.IP_Address, N.Vendor, n.MachineType, NCMPhysical.Serial, N.IOSImage, n.IOSVersion, ncmphysical.FirmwareRevision,
ncmphysical.HardwareRevision
FROM NCM.EntityPhysical NCMPhysical
INNER JOIN NCM.Nodes NCMNodes
ON NCMNodes.NodeID = NCMPhysical.NodeID
INNER JOIN Orion.Nodes N
ON N.NodeID = NCMNodes.CoreNodeID
where NCMPhysical.EntityClass = 3

Thanks and regards

thomasdrinkwater

Hello there! 

I have had a look into this from another system and have some results: 

I've not directly seen that error before. However, have you tried uninstalling and running a fresh install for the SWQL studio? 

Aside from the image error, I have run tests on the SWQL codes provided had had some additional questions/results: 

1)  Can you confirm that the account you log into SWQL Studio with has the relevant NCM permissions to obtain the data?

2)  When running with the original where clause for EntityClass = 3 I get the following error: 

"Conversion failed when converting the nvarchar value 'stack(11)' to data type int'"

I have found that the above is due to calling an on a string value column. I have added an updated version of your SWQL code below: 

SELECT

N.NodeName, N.IP_Address, N.Vendor, n.MachineType, NCMPhysical.Serial, N.IOSImage, n.IOSVersion, ncmphysical.FirmwareRevision, ncmphysical.HardwareRevision, NCMPhysical.EntityClass

FROM NCM.EntityPhysical NCMPhysical

INNER JOIN NCM.Nodes NCMNodes ON NCMNodes.NodeID = NCMPhysical.NodeID

INNER JOIN Orion.Nodes N ON N.NodeID = NCMNodes.CoreNodeID

-- where NCMPhysical.EntityClass = 3

where NCMPhysical.EntityClass = 'Chassis(3)'

I commented out the original where clause with -- and have then edited with the 'Chassis(3)'. 

If "Chassis" is not the correct object class you would want to filter by, either comment out or remove the where clause and run without additional conditions. The final column added NCMPhysical.EntityClass will advise on the correct query text to populate within the where clause results.