Change the state of CI based on a list collector field value on a catalog item

[Poorva Bhawsar]

Hi Community,

I want to change the value of CI state from abc to xyz selected on the CI list collector field of a catalog item using workflow.

This is what i did so far.

var grCI = new GlideRecord('cmdb_ci');

grCI.getValue('server_name_s');

grCI.addEncodedQuery('operational_status=8');

grCI.query();

while(grCI.next()){

    grCI.setValue('operational_status',1 );

    grCI.update();

}

[Anil Lande]

Please share your variable configuration and script you have written in workflow.

[Poorva Bhawsar]

var CIList = current.variables.server_name_s.toString();

var grCI = new GlideRecord('cmdb_ci_computer');

grCI.addEncodedQuery('sys_idIN' + CIList);

grCI.query();

while (grCI.next()) {

    grCI.operational_status = 1;

    grCI.update();

}

Here we go.

Variable name is there in script and its type is list collector.

[Anil Lande · Accepted solution]

Hi,

Use below script:

var CIList = current.variables.server_name_s.toString();
var grCI = new GlideRecord('cmdb_ci_computer');
grCI.addEncodedQuery('sys_idIN' + CIList);
grCI.query();
while (grCI.next()) {
    grCI.operational_status = 1;
    grCI.update();
}

[Poorva Bhawsar]

Yeah i have updated it later and realized that i was not using gliderecord object and the table also i need to use server instead of computer.

[Poorva Bhawsar]

Any update on the request sys id? What request sys id i need to use? Because it will vary request to request.