Query to report a user's group memberships
Does any body know of a SQL query that would report group membership for a specific user. When you view the properties of a user you can see the group memberships listed there, but I'm looking to get the same information in a SQL query. Thanks
October 27th, 2009 8:50pm
quick 'n' dirty report for the username of 'bob'. You'd likely want to throw in a prompted variable for a real report. select usr.user_name0, usr.full_user_name0, grp.user_group_name0from v_r_user usrjoin v_ra_user_usergroupname grp on grp.resourceid=usr.resourceidwhere usr.user_name0 = 'bob'Standardize. Simplify. Automate.
October 27th, 2009 9:33pm