Business App Owner and Managed By Cascade

[Community Alums]

I have a requirement to sync business app to mapped application service for the following fields owned_by and managed_by when the bus app owned_by and managed_by changes.   I am assuming it needs to be cmbd ci relationship table but not sure.  Any assistance is appreciated.

Thanks,

Chad

[Amit Gujarathi]

HI @Community Alums ,
I trust you are doing great.
Here's a basic example of what the script might look like:

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

    // Query the cmdb_rel_ci table to find related Application Services
    var rel = new GlideRecord('cmdb_rel_ci');
    rel.addQuery('parent', current.sys_id); // Assuming current record is the Business Application
    rel.addQuery('child.sys_class_name', 'cmdb_ci_service'); // Filter for Application Services
    rel.query();

    while (rel.next()) {
        // Get the Application Service record
        var appService = new GlideRecord('cmdb_ci_service');
        if (appService.get(rel.child)) {
            // Update owned_by and managed_by fields
            appService.owned_by = current.owned_by;
            appService.managed_by = current.managed_by;
            appService.update();
        }
    }

})(current, previous);