Re: BSM 9.23: How to determine what groups BSM users belong to? (210 Views)
Reply
Valued Contributor
TEX2020
Posts: 366
Registered: ‎02-02-2011
Message 1 of 4 (220 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
HP Expert
Asaf Shechter
Posts: 1,367
Registered: ‎12-09-2008
Message 2 of 4 (210 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.

Valued Contributor
TEX2020
Posts: 366
Registered: ‎02-02-2011
Message 3 of 4 (202 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
HP Expert
Asaf Shechter
Posts: 1,367
Registered: ‎12-09-2008
Message 4 of 4 (197 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.

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.