I am a new ENB admin. I would like to know how to query the system to find user name, active vs inactive status, and what collections the users belong to. What tables would you join to search for this?

Here is the script to obtain users, status, and groups where they belong to:

SELECT distinct

p.username,

c1.name FULL_NAME,

decode(c1.is_active,

1, 'Active',

0, 'Inactive') status,

h.membership_name user_group

FROM env_user_hierarchy h ,

eln_references r,

eln_people p,

eln_collections c1

WHERE h.parent_type_name = 'User Group'

AND c1.section_set_key =h.user_key

AND c1.section_set_key =p.home_collection_key

AND h.membership_key = r.target_key

and p.username<>h.membership_name

AND r.is_active =1

ORDER BY

p.username,

c1.name,

decode(c1.is_active,

1, 'Active',

0, 'Inactive'),

h.membership_name;

-PerkinElmer Technical Support