Hi,
I have searched for custom SWQL queries that others have posted which would allow me to search all downloaded configs from today for a string that matches "scp". I understand that the Config Summary exists for this purpose, but in an ideal world, I would like to be able to also use a custom SWQL query.
It seems as if any time I run a SWQL query that contains ncm.configarchive, no results are published. Even using an incredibly basic query like the following yields no results:
SELECT TOP 5 ConfigArchive.NodeProperties.Nodes.Caption, ConfigID, NodeID, Config
FROM NCM.ConfigArchive
I have found this query which is exactly what I was looking for, but again, 0 results:
SELECT top 10 n.Caption as [DEVICE], n.IP_Address as [IP ADDRESS], n.VENDOR, n.MachineType as [MODEL],MAX(c.DownloadTime) as [DOWNLOAD TIME]
FROM orion.Nodes n
JOIN NCM.NodeProperties p ON p.CoreNodeID = n.NodeID
JOIN NCM.ConfigArchive c on c.NodeID = p.NodeID
WHERE c.ConfigType = 'Running' AND c.Config LIKE '%scp%'
GROUP BY n.Caption, n.IP_Address ,n.VENDOR ,n.MachineType
