CMDB Data Certification via Workspace: Certified vs Failed attributes table

[TrishP]

Hi All,

I have been testing our CMDB Data Certification Tasks (new via CMDB Workspace) and noticed that 'failed' elements appear in the CMDB Workspace 'My Work' under the title of 'Certification exceptions' (table: sn_cmdb_ws_dm_certification_attribute_status); however, it seems there is no obvious way (at least to me) of identifying those elements that have been flagged as 'certified'.

I have attached a screenshot to illustrate the issue.

Does anyone know what table elements that are 'Certified' are recorded in?

Thanking you all in advance.

[pavani_paluri]

Hi @TrishP ,

When you run CMDB Data Certification Tasks in the CMDB Workspace:

Failed items (things that didn’t pass certification) show up in My Work → Certification exceptions.
These are stored in the table `sn_cmdb_ws_dm_certification_attribute_status`
Certified items (things that did pass certification) are not stored in that exceptions table.
Instead, they’re tracked in`sn_cmdb_ws_dm_certification_task_to_document`

That table links each CI record to its certification task and has a status field.
If the status = *Certified*, the CI has passed.
If the status = *Review Not Completed* or *Failed*, it hasn’t.

Please refer this as well: Solved: Re: CMDB DataCertification - ServiceNow Community

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P