How to write fix script?

Shashi K · ‎10-10-2022

I have a requirement when ever an Change is closed configuration item filed must not be empty.

How to write in fix script? I want only fix script

Chetan Mahajan · ‎10-10-2022

Hi Shashi,

If I correct you want to update configuration item field for closed change. once you run fix script whatever changes has empty CI it will get update with some value ? so you can refer below script

updateCI();
function updateCI(){
	try{
		var gr = new GlideRecord('change_request');
		gr.addEncodedQuery('state=3^cmdb_ciISEMPTY'); // state is closed and ci is empty
		gr.query();
		while(gr.next()){
			// your logic of updating here
			gr.setValue('cmdb_ci','b0cb50c3c0a8000900893e69d3c5885e');
			gr.update();
		}
	}
	catch(ex){
		gs.info(ex);
	}
}

Kindly mark response correct and helpful if applicable

View solution in original post

Shashi K · ‎10-10-2022

Hi Sai,

I want to apply new validation to restrict the users from should notclosing the change without ci

Saurav11 · ‎10-10-2022

Hello,

Please use the below code in your fix script. Once you run this all the closed change request will have the configuration item field emptied.

var cr = new GlideRecord('change_request');
        cr.addEncodedQuery('state=3');
        cr.query();

        while (cr.next()) {
			cr.cmdb_ci='';
			cr.update();
			cr.setWorkflow(false);
			
		}

Please mark my answer as correct based on Impact.

Shashi K · ‎10-10-2022

If CI is empty then the Change should not close

Saurav11 · ‎10-10-2022

In our script we are only changing the CI's of the CR which are already closed so we are not closing any change so you no need to worry.

Please mark my answer as correct based on Impact.

palanikumar · ‎10-10-2022

Hi,

Below code prints all the Change Requests where state is closed and CI is empty. To add restrictions you should use UI Policy

var gr = new GlideRecord("change_request");
gr.addQuery("state", "3");
gr.addNotNullQuery("cmdb_ci");
gr.query();
while (gr.next()) {
    gs.info(gr.number);
}

Thank you,
Palani