-
Re: User Group Details
Snipped from the forums:
I use this one in SQL server mgmt studio using T-SQL
Report generator query
User group details from Report generator expanded
Hope this helps Raghavendra
Tim
-
Re: User Group Details
Joy Garon
Oct 8, 2012 1:26 PM
Hi Raghav,
It's a pretty simple query...
I attached the report file also...
Joy
-
Re: User Group Details
I wrote a report for our use. Feel free to modify it for your use.
@[UsersGroups]
§Name [Group details of selected user(s)]§Company [Sealed Air Corporation]
§Description
[This query will list all groups of the selected users.]§Version [1.1]
§Arguments
[
UserID TheUserID[N] [Select user(s)]
]§Sql
[
SELECT U.Username, U.Fullname, G.Groupname
FROM Users U, Groups G, GroupMembers M
WHERE {U.UserID, TheUserID, =, OR} AND
G.GroupID = M.GroupID AND
U.UserID = M.UserID
ORDER BY G.Groupname
]@Tim and @Joy, Did we all reply at the same time? Hahaha!
Message was edited by: Michael Dekoning
-
Re: User Group Details
Dear All,
Thanks for your responses, I know this could be done by a report.
But for the Enduser, Wouldn't be helpful if this could be done by a search card ?
I have had no luck in creating the search card, Your thoughts please ?
