Query on HRSD Reporting Capabilities

mahi14141
Tera Contributor

Hello Team,

I wanted to check if it is possible to generate a report from the HRSD module that includes the following fields:

  • COE (Center of Excellence)
  • Topic Category
  • HR Service
  • HR Region
  • Country
  • Assignment Group
  • Service Type

Could you please confirm whether these data points are available in a standard report or if a custom report/dashboard would need to be created..?

Thanks in advance. 

2 REPLIES 2

SupriyaWaghmode
Mega Sage

Hello @mahi14141  , 

 

In ServiceNow HRSD, the fields you mentioned are available within the platform, but they are not all included in a single out‑of‑the-box (OOB) report.
Field Availability
Most of the requested fields can be sourced from the HR Case (sn_hr_core_case) table and related tables:

 

Steps to create new report - 

Step 1: Navigate to Report Creation

Go to All > Reports > Create New
Select:
Report Type: Table
Step 2: Select the Base Table
Choose the HR Case table:
Table: HR Case [sn_hr_core_case]


Step 3: Configure Report Columns
Click Configure > Columns and add the following:
Direct Fields (Available on HR Case)

HR Service
Topic Category
Assignment Group


Dot-Walked Fields (Important)
COE (via HR Service)
HR Service → COE
Service Type (depending on config)

HR Service → Service Type

(or directly from case if available)
Country
Opened for → Location → Country

HR Region
Depending on your setup, use one of:
Opened for → Location → Region

OR
HR Profile → Region

OR a custom field

Step 4: Add Filters (Optional but Recommended)
Click Filter and define conditions like:

Active = true
HR Service is not empty
Assignment Group is not empty


Step 5: Choose Report Type
You can select based on your need:
Table

Shows all fields row-wise
Bar / Pie Chart

Group by:

HR Service
COE
Assignment Group


Step 6: Grouping (Optional but useful)
In Group By, select:

HR Service
OR COE
OR Assignment Group


Step 7: Save and Run

Click Run
Review data
Click Save
Name it:
HRSD Case Report - COE, Service, Region


Step 8 (Optional): Add to Dashboard

Go to Self-Service > Dashboards
Click Add Widget
Select your report


Role Permissions

Ensure you have:
sn_hr_core.case_reader

HR data is role-restricted

 

If my response helped you, please click on accepted the solution and consider giving it a thumbs-up👍. This helps others find the solution faster and keeps the community thriving. Thank you for your support!😊

Thanks & Regards ,
Supriya Waghmode |ServiceNow Community Rising Star 2025
www.linkedin.com/in/supriya-waghmode

 

mahi14141
Tera Contributor

Thanks for the update Supriya,

But with the above information, when I tried getting data, I am able to get data after the case got created in system.

But I am looking before the case creation, the exact data which is configured in the system.