Data Certification for ci relationships

[Venkatesh bora]

I did the certification for servers and mainframes etc.. and I am populating the certification details like Attested by with certification Assigned to user and other reasons with the Certification Task number on the respective hardware table and it is easy for my reporting as well.

Similarly, I wanted to do the Data certification for CI Relationships (cmdb_rel_ci) table and to populate those values on the ci relationships to do the reporting.

[pavani_paluri]

Hi @Venkatesh bora ,

Go to Certification > Policies and Create a new policy targeting cmdb_rel_ci with filters like type.name = Depends on or parent.sys_class_name = cmdb_ci_server.
Use Group Certification or Individual Task Assignment.

Add Custom Fields to cmdb_rel_ci like: Certified By , Certification Task, Certification Date, Certification Reason
You can create an “After Insert” Business Rule on the cmdb_data_management_task table, filtered to records where: table_name = cmdb_rel_ci Or directly target relationship tasks via their associated policy.

You can create reports in relationship table as you will have all the data for certifications in it.

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

[Venkatesh bora]

Hi Pavani,

Thanks for the update.

What is the Policies you are referring to.

I don't see any policies under Data Certification module.

[pavani_paluri]

Hi @Venkatesh bora ,

Please create a scheduled definition with below condition

filters like type.name = Depends on or parent.sys_class_name = cmdb_ci_server.

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