Generating CIs and relationships from existing CIs using a script

[yjaques]

Sometimes you may automatically want to generate a closely related CI to an existing CI and you don't feel like it doing it all step by step in the interface, maybe you have too many or maybe you want it to run as a business rule. Recently we had a number of Java applications set as CIs for which we wanted to create a parallel set of business services and relate the business service CI to the Java app CI. There were about 35 of them so I thought I would script it instead of going through all those forms. Here's what I did:

//create an object in my Java CI table

var app = new GlideRecord('u_cmdb_ci_applications_web_jav');

//iterate through every record

app.query();

while (app.next()) {

      //make sure record meets your criteria (in my case had to be operational and installed

        if(app.operational_status==1 && app.install_status==1) {

                //create a service object

                  var serv = new GlideRecord('cmdb_ci_service');

                  serv.initialize();

                  //give it the same name as the app

                  serv.name = app.name;

                  //create the CI record

                  servId = serv.insert();

                  if(servId != null) {

                            gs.log('Added SERVICE!');

                            //create a relationship object

                            var rel = new GlideRecord('cmdb_rel_ci');

                            rel.initialize();

                            //make the parent the service

                            rel.parent = servId;

                            //make the child the app

                            rel.child = app.sys_id;

                            //define the relationship type (in my case was Depends on:: Used by)

                            rel.type = 1;

                          //create the relationship

                            relId = rel.insert();

                            if(relId != null) {

                                      gs.log('Added rel!');

                            }

                  }

        }

}