Conditional script in scheduled job

[raj10]

Hi team,

I just wanted to schedule a job with the script.

fetch all the number, comments , state, and state changed time from the incidents.

could you please help with the script. (conditional script and Run script)

Thanks for your help in advance,

raj

[Yash Agrawal1]

Hello Raj,

It is showing "Undefined" because there is no value for that record which we are searching for.

Regards

Yash Agrawal

[Yash Agrawal1]

Hello,

I just try it on my personal instance and it is working fine

I just check logs. Please create a scheduled script and Click on Execute Now button

Regards

Yash Agrawal

[raj10]

Hi Yash,

Thank you very much for your help.

am getting results for background execution, not accurate results. please find the below screenshots. state change is the same for all.

the script is throwing an error if scheduling the job.

[Yash Agrawal1 · Accepted solution]

Hello Raj,

You still using my Old version of code.

Please update your code.,i already try to create a scheduled job on my personal instance and it is giving right solution of it.

Latest code is.

var grinc=new GlideRecord('incident');
grinc.query();
while(grinc.next())
{ 
   var grmet=new GlideRecord('metric_instance');
   grmet.addQuery('id',grinc.sys_id);//updated here
   grmet.addQuery('field','incident_state');
   grmet.orderByDesc('sys_created_on');
   grmet.setLimit(1);
   grmet.query();
   if(grmet.next());
   gs.print('Number-'+grinc.number+',State-'+grmet.value.toString()+',State_Change-'+grmet.sys_created_on);
  
} 

It is the updated code,please use this one.so yhat you will geT

INCIDENT NUMBER,Its current state,and the latest state change time.

Please keep posted for more help.I try the solution,it is working fine

Regards

Yash Agrawal

[raj10]

Thanks yash for your help.

logs are not getting generated. don't know what is the issue