NCM COMPLIANCE REPORTS UPDATE IS STUCK AND ARE NOT UPDATING

By stuck, do you mean that one or more reports shows the "Waiting" like its updating, or that the date is just not updating on the report?   Have you tried selecting the report and doing an "update" or an "update all" to see if it updates manually?

The "No devices selected" tends to suggest that the policies attached to the Report don't have any devices set.    The "Cisco Security Audit" report has 5 policies assigned to it, which you can see by editing the report.   "Security Audit IP Commands",  SA Flood, Security, Services and "Security Logging Audit".  If you go into edit policies and sort by "Appears in Report", you can select the "Cisco Security Audit" report and see this.   If you edit one of them, let's say "Security Audit Flood", you should see under "Select Nodes" that by default its set to "NCM Policy Reporter selection criteria" being set to "WHERE ((NCM_Nodes.Vendor='Cisco')).    

If you want, you can change this to be a different criteria.   For some reason this one doesn't give you a list of nodes that it produces.   If you instead do a dynamic policy, you can see what nodes it will use in the report.

If you do decide to edit it, I'd highly recommend making a copy of it first and editing the copy instead!!

Thanks cnorborg , "Select Nodes" is default  ((NCM_Nodes.Vendor='Cisco')), tried creating copy of reports as well but didn't worked, but anyway problem solved by editing DB entries.

Problem was with Caching, Policy reports Stopped Caching.

Changed the policy reports Cache status to 0 (Zero) on DB and truncate table for NCM_policycache & NCM_PolicyCacheResults.

NetDev_sol  We seem to have hit this in one of our deployments.

Can you detail the steps please?

 stuartd  Steps are here.

HOPE IT HELPS