User and Group Details from Repository

[sh4kil]

Does anyone have a universe that is able to retrieve Users and the Groups they belong to in Supervisor/Repository please?

 

[sh4kil]

Its ok - found a way - used the Security universe provided by Business Objects (part of Auditor I think).

 

[skrandel]

I do not believe that the Auditor universe does this either.

The problem is that the universe is recursive. Unless you store all your users at the same level of depth, you can't build this in a simple query.

Steve Krandel
VERITAS Software

 

[vani65]

Hi Try this SQL it works for me:

SELECT
GroupName.M_ACTOR_C_NAME AS "Group Name",
OBJ_M_ACTOR.M_ACTOR_C_NAME AS "User Name"
FROM
OBJ_M_ACTOR,
OBJ_M_ACTORLINK,
OBJ_M_ACTOR GroupName,
OBJ_M_ACTORLINK GroupLink
WHERE
OBJ_M_ACTOR.M_ACTOR_N_ID = OBJ_M_ACTORLINK.M_ACTL_N_ACTORID
AND OBJ_M_ACTOR.M_ACTOR_N_TYPE <> 1
AND OBJ_M_ACTORLINK.M_ACTL_N_FATLINKID = GroupLink.M_ACTL_N_ID
AND GroupName.M_ACTOR_N_ID = GroupLink.M_ACTL_N_ACTORID

 

[sh4kil]

Thanks vani65.

The SQL generated by the Business Objects report provided similar SQL to the one you've listed.

skrandel - it is recursive and the user is shown in every group that it belongs to