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 Paul,

If you read the comment properly you can see,i said that background script is simply a example to run ,try and check the code.

And the provided code is of Scheduled job,which is giving me the correct result,but not to Raj.

@raj- will you please provide input in this,that is your query resolved or not?

Regards

Yash Agrawal

[raj10]

@Yash Agrawal 

still checking, as logs are not appearing. let you know once it is done

@Paul Morris

need to get state changed time, not incident updated time.

i think using scheduled reports, we can get last updated time.

where we can see logs/data of scheduled reports?

[Yash Agrawal1]

Hello @raj

Will you please Create the new Schedued job once again,with the below code.

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

}

You can see the exact code.

And then Save the form and CLick on the "Execute Now" Button.

-----------------------------------------

After That go to System logs>>Warning

And in Messege colounm type "*Number".

100% of your query will get resolved.

Please try it once.

Regards

Yash Agarwal

[raj10]

Hi Yash,

thanks for your help.

results are not getting properly.

Incidents Details in ServiceNow :

logs in ServiceNow :

[Yash Agrawal1]

Hello Raj,

Please tell me,that did you change the field name in "metric_instance" table.

Please keep posted.

Regards

Yash Agrawal