Is there a way i can search for a user and get to know which group he belongs to ?
Am trying to find out the ways to accomplish this, Pour in your thoughts.
a) Write a query, create a .crp and run a report.
b)
Regards,
Raghav.
Is there a way i can search for a user and get to know which group he belongs to ?
Am trying to find out the ways to accomplish this, Pour in your thoughts.
a) Write a query, create a .crp and run a report.
b)
Regards,
Raghav.
Hi Raghav,
It's a pretty simple query...
I attached the report file also...
Joy
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
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 ?
Snipped from the forums:
I use this one in SQL server mgmt studio using T-SQL
https://forum.solidworks.com/message/277440#277440
Report generator query
https://forum.solidworks.com/message/123445#123445
User group details from Report generator expanded
https://forum.solidworks.com/message/156451#156451
Hope this helps Raghavendra
Tim