CMDB Data Manager Certification Policy

[DaisyB057891995]

I am trying to create a certification policy. I need to get few field from the CI table and few fields from the related tables (I have custom related tables, but for instance lets take CI relationship as an example) to be validated.

What's the best way to achieve this, as the certification field does not allow fields from other tables?

[DaisyB057891995]

Thanks Atul for the response.

I also need to use a filter for "name DOES NOT START WITH <substring>" for cmdb_ci table. As we do not have an existing filter for DOES NOT START WITH on this field, I was checking if I can use a script include for it. However I am unable to make it work using "sys_idINjavascript&colon; new <ScriptInclude>().<FunctionName>();

Is there something I am missing here, my function is below:

queryCI: function() {

        var ids = [];

        var query = 'install_status!=7^u_production=true^sys_class_name=cmdb_ci_service^ORsys_class_name=cmdb_ci_service_by_tags';

        var ciRec = new GlideRecord('cmdb_ci');

        ciRec.addEncodedQuery();

        ciRec.query();

        while (ciRec.next()) {

            if (ciRec.name.indexOf('<substring1>') != 0 && ciRec.name.indexOf('<substring2>') != 0) {

                ids.push(ciRec.sys_id.toString());

            }

        }

        return ids.join(',');

    }

[DaisyB057891995]

Thanks all for your inputs.

However, separate Data Policies would not work for my case, as I want the support group of the CI to review the tasks generated from it.

For example, if I create the data policy record on the cmdb_rel_ci table, I cannot dot walk to assign the task to the CI's support group, as it looks only for the group fields on the cmdb_rel_ci table.