Report or SQL Query to Identify Unused Departments in Department Tree — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report or SQL Query to Identify Unused Departments in Department Tree

in Reporting and Analytics for HCM 1 comment

Hi Team,

We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that:

  • Have no associated employees

If you’ve encountered a similar scenario before, could you please share the SQL query or approach you used?

Thanks in advance for your support!

Best regards,

Mahendra

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!