Can I report on when an HR Case is assigned?

Rob Sestito
Mega Sage

Hey SN Comm!

I am looking to see if I can create a report on the HR Case Table - specifically, I need to know if I can do the following:

  • How many Cases were assigned out in the day (today), by rep

So, the report needs to show cases that were assigned today to someone.

Is this possible?

Thanks,

-Rob

1 ACCEPTED SOLUTION

Rob, so far you created a metric based on the assigned to person.  If you want to look at it by group, a metric on the assignment group would be needed.  The same database view should help you.

Also this lab on the developer portal may help you better understand metric reporting.  Of course it is based on Incident, but incident also extends task just like HR Case:

https://developer.servicenow.com/app.do#!/event/knowledge18/LAB0212/knowledge_18_LAB0212_lab_2__repo...

View solution in original post

15 REPLIES 15

Sadly I'm a novice with DB views. Maybe @Michael Ritchie can help here? He's much more technically adept than I am. 🙂 

 

Lena

Thank you Lena!

Rob, so far you created a metric based on the assigned to person.  If you want to look at it by group, a metric on the assignment group would be needed.  The same database view should help you.

Also this lab on the developer portal may help you better understand metric reporting.  Of course it is based on Incident, but incident also extends task just like HR Case:

https://developer.servicenow.com/app.do#!/event/knowledge18/LAB0212/knowledge_18_LAB0212_lab_2__repo...

Thanks, @Michael Ritchie - I was able to get what I needed.

Thank you for the resources as well!

-Rob

Awesome glad to hear you got this working!