How to query active users in ESS

We need to determine which users are marked as Active in ESS.

• Enterprise ERP

• EERP

• Employee Self Service

• ESS

Informational.

There is no way to search for Active users in ESS, however, the following SQL script will return a query of all active user accounts:

select * from wbsecure where wbse_active = 'Y'

Please reach out to EERP Human Resources Support with any additional questions.