SCCM 2012 Prompt User Name To Remote Control Computer

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.

June 24th, 2013 11:22pm

Im not sure that Im following you. You want to create a Collection that you can prompt for a user name so that you can RC then? I think this is correct. This would not make a lot of sense, particularly on a busy site.

It does make sense to create a query and you can use this for RC too. Use this query if you want to locate PCs by that last logon user but prompt for the user name each time.

http://smsug.ca/blogs/garth_jones/archive/2013/06/29/find-pc-by-last-logon-user-prompted.aspx

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2013 9:05pm

Thank you. That is exactly what I want to do, but when I put this into the WQL I get an error:

This query has a syntax error. Are you sure you want to save it?

I have found this information before, but keep coming up with the same error. Am I doing something wrong here? Or not doing something else that would make this WQL work?

July 1st, 2013 4:44pm

You are doing this as a Query NOT a collection right? What error are you getting?
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2013 3:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics