Report on both HR Task and HR Case in the same report.

[JD292]

Hello, 

I am trying to create a pretty basic closed HR Task report, where I run into trouble is I also want the report to contain the name of the HR Service the HR Task is sitting on and the Assigned To of the HR Case.

In PeopleSoft, I would just join the HR Task Table and the HR Case Table. Is that the same in ServiceNow? If so, how would I go about doing this?

I have the Reporting Admin role, but not a full Admin role. If I need to have someone with a full Admin role complete the setup, I can, I just need to be able to walk them through it as well.

Thanks much!

J Dean

[Ashutosh Munot1]

HI,

So you can create a report on task table and filter only this two task type's as below:

Thanks,
Ashutosh

[JD292]

Thank you for your response Ashutosh. Is your example from the View/Run on the Filter Navigator. I am asking because my screen does not mirror yours, I do not have anything above the conditions section. Do I need to select something to get these fields? Do I need full Admin access to see these fields?

[Ashutosh Munot1]

Hi,

You can use choose column on your right. I am using old UI for reporting and not the new one so it is not same.

Thanks,
Ashutosh

[Prateek kumar]

Report on HR Case and dot-walk to HR task fields. This way you'll have all the fields from HR task and case in the single report.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/co...

Please mark my response as correct answer and helpful if it helped solved your question.
-Best Regards
Prateek kumar