Data Certification - "Date last verified" on Ci records

[benhaw]

Hi all,

We are using the excellent Data Certification plugin to have Ci owners verify the Ci's under their control.

If the Ci owner updates the Ci, we have the "Updated" field that gets the new timestamp.

But we also want a timestamp on the Ci record like "date last verified".

Whenever they verify an item and mark it as OK.

Does the Ci itself get an update after the Certification task has been closed?

Or are we approaching this the wrong way?

I saw a checkbox called "Needs verification" but that is not what we have in mind here.

This would allow us to sort, filter on this and even create automatic data certification schedules for items that have not been reviewed for over 3 or 6 months.

Benny

[mpmacconnell]

We are just now looking into implemting Data Certification and trying to figure out this same type of solution. Did you ever figure anything out on this one?

[melissahill]

we also need this - has anyone figured this out?

[Manoj75]

Hi All,

      Create below fields in CMDB_CI Table and then create after update business rule in cert_element table and add below script . It works 🙂 

Note : Script will update validate_Date and validated_by once all elements are certified for CI. 

1. Validated_Date

2. Validated_by

(function executeRule(current, previous /*null when async*/)
{
var ga = new GlideAggregate("cert_element");
ga.addQuery("cert_task",current.cert_task);
ga.addQuery("id",current.id);
ga.addAggregate("COUNT");
ga.query();
var total = 0;
if (ga.next())
total = ga.getAggregate("COUNT");
gs.log("GGG Total Records for Validation Count :"+total);

var ga_success = new GlideAggregate("cert_element");
ga_success.addQuery("cert_task",current.cert_task);
ga_success.addQuery("id",current.id);
ga_success.addQuery("state", "Certified");
ga_success.addAggregate("COUNT");
ga_success.query();
var Success = 0;
if (ga_success.next())
Success = ga_success.getAggregate("COUNT");
gs.log("GGG Total Records Validated :"+Success);

if(total == Success)
{
gs.log("GGG CI Data Validation Completed");
var ci= new GlideRecord('cmdb_ci');
ci.addQuery('sys_id',current.id);
ci.orderByDesc('sys_updated_on');
ci.query();
gs.log("GGG Row Count"+ci.getRowCount());
if(ci.next()){
gs.log("GGG CI Validation Details updated by "+gs.getUserID());
ci.u_validated_by=gs.getUserID();
ci.u_validation_date=current.sys_updated_on;
ci.update();
}

}
else gs.log("GGG CI Data Validation Pending");
})(current, previous);

Regards,

Manoj Nagarajan.

[adamtoth]

Have there been any updates for a simpler method to add date certified and certifier name?