Re: BSM 9.23: How to determine what groups BSM users belong to? (222 Views)
Reply
Valued Contributor
Posts: 419
Registered: ‎02-02-2011
Message 1 of 4 (232 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
Posts: 1,622
Registered: ‎12-09-2008
Message 2 of 4 (222 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
Posts: 419
Registered: ‎02-02-2011
Message 3 of 4 (214 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
Posts: 1,622
Registered: ‎12-09-2008
Message 4 of 4 (209 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.