How to update CMDB_CI state with business rule on change state to implement

[Darren32]

Hi

I've created a business rule on the change_request table which is triggered when change state goes to implement and the action is supposed to update the affected configuration item state to "in maintenance".

I can see in the business rule debug that this is being triggered however, it isn't changing the state of the CI. Is the business rule configured correctly?

[Alikutty A]

Hi,

Can you make this to an After BR and see if it works for you?

Thanks

[Michael Fry1]

Since the update is occurring on the Change Request table, you'll have to use a GlideRecord to query the CI and update the State.

[Darren32 · Accepted solution]

Thanks

I wrote the below script which works.

(function executeRule(current, previous /*null when async*/) {

// Add your code here

var CMDBci = new GlideRecord('cmdb_ci'); //glide record to ci
CMDBci.get('sys_id', current.cmdb_ci); //grab the sys_id matched from current ci
CMDBci.setDisplayValue('install_status','3'); //update to in maintenance
CMDBci.update();

})(current, previous);

[RiteshSwarnakar]

The below Business Rule Script is working fine for the Scenario: To change the status of all Affected CIs to Retired when Change Request state changes to Closed. 

You can change the script according to your requirement.

When to run : set When as async and Filter Conditions as State changes to Closed

 

Thanks,

Ritesh