SQL Query to get group membership
Updated: 21 May 2010 | 2 comments
I'm trying to write a query to gather all users in each Remove Desktop Users group for each computer. I have found the RDP group in table Evt_NS_Item_Management but I don't know where the association table is that ties the user to that group/item.
Any help would be appreciated.
Thanks
discussion Filed Under:
Comments
That should read Remote
That should read Remote Desktop Users.
I use the following in my SQL where clause
AND
v.[guid] in
(
select ResourceGuid
from CollectionMembership
where CollectionGuid = 'COLLECTION_GUID'
)
--- Replace COLLECTION_GUID with the guid of the collection you are trying to verify membership of.
~Sean
Would you like to reply?
Login or Register to post your comment.