I would like to create a query that prompts me for the last logged in user so that I can create a single computer collection to remote control. Sometimes our computer names are generic and I don't know the name of the computer, but we always know the name of the user. I've tried adding a Collection Variable called User_Name and then a query:
select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.LastLogonUserName like "@User_Name"
No luck, though.