Hi,
We would like to obtain the Overall Configuration Changes Snapshot data via the SolarWinds API.
Note we want the actual data and not to embed the SolarWinds widget in our user interface.
Please can you assist.
Regards,
Andrew
Anyone have any ideas whereabouts I would look for this information within SWQL Studio?
I asked the NCM dev team to answer this question. Hopefully you'll have an answer soon.
Much appreciated - I will await their answer.
And here's the query:
select distinct CASE WHEN CacheResults.DiffFlags = 1 THEN 'changed' WHEN CacheResults.DiffFlags = 0 THEN 'unChanged' ELSE 'unknown' END as NCMNodeStatus, NCMNodeProperties.NodeID, Nodes.NodeID as CoreNodeID, Nodes.VendorIcon, Nodes.Caption, Nodes.IPAddress, CacheResults.DiffFlags, Nodes.DetailsUrl, Nodes.Status, Nodes.ChildStatus, Nodes.Vendor, Nodes.Icon, OrionVendors.Icon, ConfigTypeFROM Cirrus.NodeProperties as NCMNodePropertiesjoin Orion.Nodes as Nodes on Nodes.NodeID=NCMNodeProperties.CoreNodeIdjoin Orion.NodesCustomProperties as OrionCustomProperties on Nodes.NodeId= OrionCustomProperties.NodeIdinner join Orion.Vendors AS OrionVendors ON Nodes.Vendor=OrionVendors.Nameleft join( select DiffFlag as DiffFlags, NodeID, ConfigType from Cirrus.LatestComparisonResults where ComparisonType=4 ) as CacheResultson NCMNodeProperties.NodeID=CacheResults.NodeID ORDER BY Nodes.Caption ASC
