Collection from Top Console User in a group by PC name
We needed to create a collection to send out a product to a specific group of users. After scouring the net I found this query. Looks like MyITForum guys figured it out a while ago :-)
Create a collection and paste this into the code section. Make sure to change the "<domain>\\<group>" to what you need.
select distinct SMS_R_System.Name
from SMS_R_System inner join SMS_G_System_SYSTEM_CONSOLE_USAGE on SMS_G_System_SYSTEM_CONSOLE_USAGE.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_SYSTEM_CONSOLE_USAGE.TopConsoleUser in
(select distinct UniqueUserName from SMS_R_User where UserGroupName = "<domain>\\<group>")
Thanks to guess where :-)
http://www.myitforum.com/forums/m_181172/printable.htm