CMDB Data Certification via Workspace: Certified vs Failed attributes table

TrishP
Mega Guru

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.

 

4 ACCEPTED SOLUTIONS

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

View solution in original post

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

View solution in original post

Tony Branton
ServiceNow Employee

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.

View solution in original post

Thank you so much Tony, I appreciate all the feedback and workarounds you have provided regarding this topic. I look forward to a more sustainable solution that better supports my stakeholders.
Thanks again. 

View solution in original post

11 REPLIES 11

Hi @TrishP ,

 

Could you Please accept my response as solution. I think the solution that you have accepted is the reply that you have given.

 

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

Tony Branton
ServiceNow Employee

Hi @TrishP , 

The Data Certification dashboard allows you to view certification records from all tasks associated with a certification instance (see below).  You can filter to show all records, only passed, or only failed.  The dashboard was added to CMDB Workspace in Q3 '25 and can be accessed from the Quick Links on the home page.

Screenshot 2026-02-02 at 4.41.01 PM.png

 

Hi @Tony Branton 
Fantastic! thank you for your guidance! I will have access to the Dashboard once we upgrade; however, how can that data be reported on, so that a report can be sent to our Risk team, to prove that certification has taken place? That is the missing piece for me.
Thanks again

 

Tony Branton
ServiceNow Employee

Hi Trish,


As of CMDB Workspace 8.0, there's no export functionality exposed in the Data Certification dashboard list views.  While it's a capability we'll look to add in the not too distant future, short term you could try going directly to the sn_cmdb_ws_dm_certification_attribute_status list  view in UI16 and export from there.

TrishP
Mega Guru

Hi Tony,

Thank you for taking the time to provide your feedback on this topic.

I have tried to create a report on the nominated table, the issue is that, for some bizarre reason, SN thought it was a good idea to create one record with all certification results, failed and certified, in one long JSON string, it sounds like it was a rushed job, wanting to implement the new Data Certification Process! <disappointed>
This is crucial for a governance/risk team as, the idea of having users certify their data is to actually provide  visible, legible details to the the consumer of data: Data Stewards, Governance and Risk teams in the organisation.
I hope this can be addressed as a matter of priority.
Thanks again Tony
Regards
Patricia