CMDB Health | What is the purpose of the "Active" field in the "CMDB Health Result" table

[Jacques Clement]

Hi - I am working on a large CMDB implementation and so far I have not managed to see the value for the Recommended Fields score. I keep going above the threshold which is currently set at 700K.

However, after running the jobs, I can see that I only have 100K (active) entries in the cmdb_health_result table; so I assume I should see the Recommended score given I am under the 700K threshold.

Now if I'm listing all entries for this metric, including the inactive ones, then I get 750K records, which is above the 700K threshold and would explain why it does not show the metric score.

Would anyone see if I am missing something here?

[Sandeep90 · Accepted solution]

@Jacques Clement The active flag is used to display the data from previous runs while the jobs are still running, once the job finishes then the inactive ones are turned to active and the older active ones are deleted.  In order to check if the jobs are still running check the cmdb_health_metric_status table.