Can I report on when an HR Case is assigned?

[Rob Sestito]

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

[Lena_Latham]

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

Lena

[Rob Sestito]

Thank you Lena!

[Michael Ritchie · 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...

[Rob Sestito]

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

Thank you for the resources as well!

-Rob

[Michael Ritchie]

Awesome glad to hear you got this working!