Query To Pull User Category Of Population

Hello all,

We have a requirement to pull the user category information for users. We have written the below query but it is still returning as null.

Is there any changes we can make to this? Or is there any reports that we can run to get this information?

Query:

Select count(*) as DEFAULT_user
from per_users pu,
per_ldap_users plu
where pu.username = plu.username
and plu.USER_CATEGORY='DEFAULT'
and pu.ACTIVE_FLAG = 'Y' AND
pu.SUSPENDED = 'N'