Can't create follow on task for CMDB Completeness dashboard

[ajayr]

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

ctomasirichardbrounsteinlchicoine

[LaurentChicoine]

Hi Ajay,

From my understanding, Follow on task are actually used for audit field (expected value for a field). However there is the "Recommended Field Remediation" table for what you are trying to do.

To configure them, you should:

1. Configure your recommended field in the CI Class Manager
2. Go to Health Preference -> Health Metrics -> Metric: Recommended, and activate the checkbox for Create Task
3. Make sure the CMDB Health Dashboard - Completeness Score Calculation Scheduled job is running.

This should automatically create the tasks you are looking for.

[ajayr]

Hi Laurent,

That was really helpful in regards of creating a task.

But one point here, this will assign the task always to a static particular group. We would like to dynamically assign it to the grou

Is there any possibility to do that.

Thanks

Ajay

[ajayr]

I just tested and it is creating record in recommended_field_remediation table . Is there any possibility to create in Follow on task table.

I tried using business rule but as mentioned in my above description the BR is not trigggering at all in Jakarta while as in Helsinki it was working fine.

[LaurentChicoine · Accepted solution]

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.