Count of Incidents assigned today

[Nomava Ntaka]

Dear Community

I hope someone can help me. I would like to report on all incidents assigned today.

This mean that regardless if the state changed to closed or ohhold - but the count of incidents assigned should not chane after the status is moved to anather status. I hope I male sense.

The goal for this is to track how many incidents are assigned daily.

Please advise on how I can do this.

Mava

[Priti Golam1]

Hello Nomava,

 Kindly go through below link it might be helpful

https://community.servicenow.com/community?id=community_question&sys_id=618ccba5db9cdbc01dcaf3231f96...

If my answer solves your problem mark it as correct if it helps you anyway mark as helpful.

Thanks,

Priti Golam

[Nomava Ntaka]

Hey Priti

thank you for the reply, this link is for scheduling reports not really what is assigned to a person on the day - regardless if it was closed or status changed.

I need something from open to assigned.

[Andrew_TND]

That does sound like a tricky one.

You cant use the sys_history_line table in the reporting for some reason so to get the info you need you'll need to extract the information from the table and them develop a graph in excel. 

On the Task level I would use Assigned to - changes from empty and updated today but wouldnt be accurate as soon as someone updates it your data will change so will always be fluid.

Where as you download the sys_history_line item you can see below... That way you've got old value, new value and the date it was updated.

Please mark as helpful/correct if this has answered your question.

[Adam Stout]

I would create an assignment SLA and from that, report when the SLA completed.  That is also going to give a measurement of how long it takes to assign tasks which is always something good to keep an eye on.

If I didn't do that, I would create a scripted metric to measure this which again, you can easily report on the end date.