ALERT! The community will be read-only on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only on April 19, 8am Pacific as the migration begins.Read more for important details.
Absent Member.
Absent Member.
7348 views

Report of users that are in two specific groups

Jump to solution
User is looking for a report that indicates if a user is the member of select groups. The simplist way I could think of is to run a report of group 1 using the Administrator in the browser, copy and paste into Excel and add a field with the group name. Do the same for group 2 and then sort on name.

SQL query looks like it could be pretty complicated. Any other suggestions?
Tags (1)
0 Likes
1 Solution

Accepted Solutions
Absent Member.
Absent Member.
The SQL query is pretty straightforward, is this something they want to run repeatedly as a report in SBM, or a one-off exercise that you/they would do from SQL manager? Look at the Schema doc, the TS_MEMBERS table provides a set of USERID/GROUPID pairs that show which users belong to which groups.

Also the new Solution Reporting capability which was demoed in the SBM11 Sneak peak could provide a nice way to do custom Group Membership reports, if you're planning to upgrade when it arrives:

http://www.screencast.com/t/yNH3LsRe4PGY

View solution in original post

0 Likes
2 Replies
Absent Member.
Absent Member.
The SQL query is pretty straightforward, is this something they want to run repeatedly as a report in SBM, or a one-off exercise that you/they would do from SQL manager? Look at the Schema doc, the TS_MEMBERS table provides a set of USERID/GROUPID pairs that show which users belong to which groups.

Also the new Solution Reporting capability which was demoed in the SBM11 Sneak peak could provide a nice way to do custom Group Membership reports, if you're planning to upgrade when it arrives:

http://www.screencast.com/t/yNH3LsRe4PGY

View solution in original post

0 Likes
Absent Member.
Absent Member.
Thanks Jeff. Didn't think about using ts_members. That was the perfect solution. My user is on 2009R3 with no intention to upgrade so SBM11 wouldn't help.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.