Comments
-
I figured out the issue. The account we use for SWQL Studio had the NCM permissions set to "none". Changing it to WebViewer fixed it. The reason for the mismatch between SWQL Studio and Reports/Widgets is that I use an admin account on the website, and a read-only account in SWQL Studio.
-
BldgNo is a custom property we use. But anyway, here are a few other queries that return no results in SWQL Studio. These same queries work in reports. SELECT NodeID FROM NCM.InterfacesSELECT MAC FROM NCM.ArpTables SELECT NodeID FROM NCM.Nodes SWQL Studio: Report: Queries on other tables work in SWQL Studio. I…