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 · Accepted solution]

Hi @TrishP 
The table sn_cmdb_ws_dm_certification_task_to_documentc only creates one record per certification task/document.
Inside that record, it stores all the certification results (Certified, Failed, etc.) together in one field called *Attribute Status*.
Because everything is bundled into one field, you can’t easily report on which individual attributes passed or failed.

Reporting tools like list views or dashboards expect one row per attribute with its own status.
Since the data is “packed” into a single field, you can’t filter or group by Certified vs Failed without extra work.
The only table that gives you clean, per‑attribute records out‑of‑the‑box is the exceptions table (`sn_cmdb_ws_dm_certification_attribute_status`), but that only shows failures.

For certified attributes, you’ll need to build something custom:
Write a script or scheduled job to unpack the Attribute Status field and store each attribute + status in a new table.
That way, you’ll have a clean dataset for reporting.
If you only care about high‑level metrics (like % certified vs failed), you can use the task completion percentages, but that won’t show details per attribute.

You’re right — out‑of‑the‑box, ServiceNow doesn’t give you a neat way to report on certified attributes. If you want detailed reporting, you’ll need to normalize the data yourself (custom table or script).

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

[TrishP · Accepted solution]

Hi Pavani,

Thank you so much once again for your very prompt response, it is appreciated.
And thank you for confirming my fears: there is currently no way of getting a full report of failed AND certified elements; I believe this is a design oversight, as, without the ability to thoroughly report, Data Certification is just a tick boxes (excuse the pun) exercise.
I must say, the whole Data Certification via Workspace is not user friendly and a very poorly designed process.
For now, we will just have to endure this pain.
Thank you so much once again.
Regards
Trish

[Tony Branton · Accepted solution]

I hear you and sympathize with you on the JSON string -  it was used to with the intention of improving scalability, which was a drawback of the elements table used in the legacy Data Certification application.

One of the objectives of the Data Certification Dashboard was to provide a way to report on the fields being certified.  Exporting results was a stretch goal that we'll revisit in a future release (it's on the roadmap), together with addressing access to the dashboard for non-assignees.

[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

[TrishP]

Hi Pavani,
Thank you so so much for your very prompt and thorough response.
I have analysed the data on both the nominated tables, based on our Data Certification Tasks and found that,  the data stored in the "sn_cmdb_ws_dm_certification_task_to_document" table, seems to add a single record for the CMDB Task/Document ID and all of the certification elements (with their certification values -Failed, Certified, etc) into the 'Attribute Status' attribute of the table.
This is an issue as it can not be used for reporting, displaying which elements in the Document passed  certification and which ones failed.
This is shown in the attached example.
Thank you so much, I hope you can kindly provide your thoughts on this.
Kindest regards
Trish

[pavani_paluri · Accepted solution]

Hi @TrishP 
The table sn_cmdb_ws_dm_certification_task_to_documentc only creates one record per certification task/document.
Inside that record, it stores all the certification results (Certified, Failed, etc.) together in one field called *Attribute Status*.
Because everything is bundled into one field, you can’t easily report on which individual attributes passed or failed.

Reporting tools like list views or dashboards expect one row per attribute with its own status.
Since the data is “packed” into a single field, you can’t filter or group by Certified vs Failed without extra work.
The only table that gives you clean, per‑attribute records out‑of‑the‑box is the exceptions table (`sn_cmdb_ws_dm_certification_attribute_status`), but that only shows failures.

For certified attributes, you’ll need to build something custom:
Write a script or scheduled job to unpack the Attribute Status field and store each attribute + status in a new table.
That way, you’ll have a clean dataset for reporting.
If you only care about high‑level metrics (like % certified vs failed), you can use the task completion percentages, but that won’t show details per attribute.

You’re right — out‑of‑the‑box, ServiceNow doesn’t give you a neat way to report on certified attributes. If you want detailed reporting, you’ll need to normalize the data yourself (custom table or script).

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

[TrishP · Accepted solution]

Hi Pavani,

Thank you so much once again for your very prompt response, it is appreciated.
And thank you for confirming my fears: there is currently no way of getting a full report of failed AND certified elements; I believe this is a design oversight, as, without the ability to thoroughly report, Data Certification is just a tick boxes (excuse the pun) exercise.
I must say, the whole Data Certification via Workspace is not user friendly and a very poorly designed process.
For now, we will just have to endure this pain.
Thank you so much once again.
Regards
Trish