NCM Devices Without Recent Config Backup

What this query does

Find NCM-managed devices that have not had a config backup in 7+ days

SWQL Query

SELECT n.NodeName, n.IPAddress, MAX(nc.DownloadTime) AS LastBackup
FROM NCM.Nodes nn
JOIN Orion.Nodes n ON nn.CoreNodeID = n.NodeID
LEFT JOIN NCM.NodeConfigs nc ON nn.NodeID = nc.NodeID
GROUP BY n.NodeName, n.IPAddress
HAVING MAX(nc.DownloadTime) < ADDDATE('day', -7, GETDATE())
   OR MAX(nc.DownloadTime) IS NULL
ORDER BY LastBackup ASC

NCM

backup

compliance

audit

Source:THWACK KB· SolarWinds THWACK Knowledge BaseView original

Unlock the full POLARISNOC hub

AI-powered SWQL generation, script management, CVE tracking, and verified solution intelligence.