Can I report on when an HR Case is assigned?

Rob Sestito · ‎11-18-2019

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

Michael Ritchie · ‎11-19-2019

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

VShine · ‎08-24-2020

@Michael Ritchie

I have created a metric definition, database view for Assignment group & assigned to. I want my metric instance to close when case is close. I try using code from "Open" incident metric OOB one. But that one is running on "Active" field vs mine is running on "Assignment group"/ "Assigned to". Here is the script I am trying to use. My Metric instances staying open even when Case is close.

Please help me!

Here is the case: