Compliance Audit involving relationships without using scripted audit

[victor21]

Hi Listers,
For the sake of optimization, is it possible to create a certification filter (cert_filter) that evaluates all apache web servers in the [cmdb_ci_apache_web_server] class for relationship of type "Hosted On" on Windows Servers in cmdb_ci_win_server class without the need to used scripted audit?. If so, how can we do this since cert_ci_rel_cond does not seem to allow this?

Thanks in advance for your inputs

Regards,
Victor

[Mark Manders]

You can build the query through the CMDB Query Builder. 

[mikkojuola]

Hi victor21,

Another way to do data audits without scripting is to use Data Content Manager. It's a data-model-driven data quality management plugin for ServiceNow where you would first define a blueprint (=data model) like this:

You can add all kinds of requirements into these blueprints, like conditional relationships, conditions for different attributes, duplicate checking etc. And then, you run an audit against the blueprint to see how compliant your data is against the required data model.

Finally, with Data Quality Workspace, you enable "data providers" (the people responsible for the data) to fix the issues with a couple of clicks.

If you're interested, you can find more information about the plugin from the ServiceNow Store or from this website. And you can also book a demo to see it live and ask further questions.

I hope this helps or at least points out an alternative way to manage data quality in CMDB.

Cheers,

--Mikko

[victor21]

Hi Mikko,

Thanks for your response - this surely looks interesting and I will investigate it.

Regards,

//Victor