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
