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,

I will strongly suggest you, try the code on Background Script.

so that you can get the result understanding.

I want actually states(In Progress) instead of state number as 2 then.

gs.print('Number-'+grinc.number+',State-'+grmet.value.toString()+',State_Change-'+grmet.sys_created_on);

Regards

Yash Agrawal

[raj10]

Hi Yash,

what do you mean background script?

getting below error

[Yash Agrawal1]

Hello Raj,

The background script is something, where you can try and test you code.

So to perform that ServiceNow provides you, a module called as "Background Script".

Please try and run the provided code. Here first, so that you can get the resulting understanding here.

Regards

Yash Agrawal

[Yash Agrawal1]

Hello Raj,

Please check the updated code.

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);
  
}

Please Mark it helpful/correct if my answer helps in any way to resolve your query.
Reach out to me if any more help required.

Regards

Yash.K.Agrawal

[raj10]

Hi Yash,

Most of the result is coming as Undefined.

 and the same code is not running in a scheduled job. why?