Re: BSM 9.23: How to determine what groups BSM users belong to? (118 Views)
Reply
Valued Contributor
TEX2020
Posts: 344
Registered: ‎02-02-2011
Message 1 of 4 (128 Views)

BSM 9.23: How to determine what groups BSM users belong to?

Hello,

 

Does anyone know how I would determine which group each user is assigned to in BSM 9.23? 

 

If I use TopazBrowser tool, I can see the group definitions in the group_auth table... but I still do not know how to map each user into what group they are assigned to.

 

Is there a way to determine what group each of my users in BSM are assigned to? Maybe a sql statement or quiery?

 

Any information greatly appreciated.

 

Thanks.

Tex2020
Please use plain text.
HP Expert
Asaf Shechter
Posts: 1,175
Registered: ‎12-09-2008
Message 2 of 4 (118 Views)

Re: BSM 9.23: How to determine what groups BSM users belong to?

did you try looking at the UI??

in Users Management select the user and click on the "Hierarchy" tab on the right side.

Please use plain text.
Valued Contributor
TEX2020
Posts: 344
Registered: ‎02-02-2011
Message 3 of 4 (110 Views)

Re: BSM 9.23: How to determine what groups BSM users belong to?

Asaf,

 

I do see the group assignments in the BSM UI under USer Management, but Is there a query I can run to get this same information from the database?

 

Any info appreciated.

 

Thanks.

Tex2020
Please use plain text.
HP Expert
Asaf Shechter
Posts: 1,175
Registered: ‎12-09-2008
Message 4 of 4 (105 Views)

Re: BSM 9.23: How to determine what groups BSM users belong to?

you can look at USERS table in the MNG DB.

i dont know if we keep this assignment info in the DB and in which table.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation