How to check total ticket assigned to a user using script?

Ankit49 · ‎12-14-2018

How to check total ticket(incident) assigned to currently login user by using script?

Harsh Vardhan · ‎12-14-2018

here we go.

sample script , just to check incident.

you can check any other table as well. make the modification based on your need.

var count=0;
var gr = new GlideRecord('incident');
gr.addEncodedQuery('stateNOT IN6,7,8');
gr.addQuery('assigned_to',gs.getUserID());
gr.query();
while(gr.next())
{
count++;
gs.print(gr.number);
}
gs.print(count);

View solution in original post

Sanjeev Kumar1 · ‎12-14-2018

Hi,

Go to --> Module

Create a new module "Assigned to me" under Incident Application.

Using following condition

javascript:getMyAssignments()

Ankit49 · ‎12-14-2018

Thanks sk, But how can i achieve that by using script

Sanjeev Kumar1 · ‎12-14-2018

Hi,

you need to use GlideAggregateAPI.

For more detail see it.

https://docs.servicenow.com/bundle/london-application-development/page/app-store/dev_portal/API_reference/GlideAggregate/concept/c_GlideAggregateAPI.html#r_GlideAggregate-getAggregate_String_String

Devyani_6 · ‎12-14-2018

Hi Ankit,

Try below script in Background scripts to get total incidents assigned to currently logged in user.

var gr = new GlideRecord("incident");
gr.addQuery("assigned_to",gs.getUserID());
gr.query();

var count = gr.getRowCount();
gs.print(count);

Regards,
Devyani