Can't create follow on task for CMDB Completeness dashboard

ajayr · ‎01-08-2018

Hi ,

Our requirement is to create a follow on task for the CIs which are not complete (means where the recommended fields are empty).

As OOTB we can create follow on task for Audit type but there is no way to create follow on task for Recommended type.

In order to accomplish it, I tried to do it via a business rule. By creating business rule on cmdb_health_result table and on insert and update of record and Metric is 'Recommended' -> create entry in Follow on task table.

Interestingly, the business rule is not getting triggered even if there is any insert/update on table cmdb_health_result table. And this is specifically happening in Jakarta version.

While as the business rule is getting executed in Helsinki version.

Does anyone know any other better way to accomplish this task of creating Follow on task in case of Recommended metric type.

Thanks,

Ajay Raina

ctomasi richardbrounstein lchicoine

LaurentChicoine · ‎01-09-2018

For the assignment group, I did test and I was able to do it using before insert business rule on the task being created.

As for using the Follow on task table, it is not it's purpose and the CMDB health script are protected (not viewable or editable). So I would not recommend trying to use Follow on task instead of the provided recommended_field_remediation table. That would probably implies to fully rebuild the scripts creating and managing the task instead of using OOTB ones.

I will try to look on my free time if there is an alternative for the business rule you were using on cmdb_health_result but it is not the intended use by ServiceNow.

View solution in original post

ajayr · ‎01-09-2018

Thanks a lot Laurent you are a champ :-),

I totally agree with you to use recommended_field_remediation table for recommended type, as there are underlying OOTB objects for the same.

I tested at my side and it worked perfectly.

Thanks a ton 🙂