Re: BSM 9.23: How to determine what groups BSM users belong to? (180 Views)
Reply
Valued Contributor
TEX2020
Posts: 358
Registered: ‎02-02-2011
Message 1 of 4 (190 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,302
Registered: ‎12-09-2008
Message 2 of 4 (180 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: 358
Registered: ‎02-02-2011
Message 3 of 4 (172 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,302
Registered: ‎12-09-2008
Message 4 of 4 (167 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.