NCM Compliance Policy Violations

What this query does

Find all devices failing NCM compliance policy rule checks

SWQL Query

SELECT n.NodeName, n.IPAddress, cp.PolicyName,
       cr.RuleName, cr.LastChecked, cr.Status, cr.FailReason
FROM NCM.Nodes nn
JOIN Orion.Nodes n ON nn.CoreNodeID = n.NodeID
JOIN NCM.CompliancePolicies cp ON 1=1
JOIN NCM.CompliancePolicyRuleStatus cr ON nn.NodeID = cr.NodeID
  AND cp.PolicyID = cr.PolicyID
WHERE cr.Status = 'Fail'
ORDER BY n.NodeName

NCM

compliance

policy

security

audit

Source:POLARISNOC· POLARISNOC Original

Unlock the full POLARISNOC hub

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