SQL Query to get group membership

dingersoll's picture
dingersoll
May 11th, 2009

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
 

Filed under: , ,
0 votes
dingersoll's picture
dingersoll
27 weeks 6 days ago

That should read Remote

That should read Remote Desktop Users.

0 votes
Sean_Ebeling's picture
Sean_Ebeling
27 weeks 6 days ago

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

0 votes