Thanks everybody!!! SMS_UserMachineRelationship was the key instead of SMS_R_System.IsAssignedToUser is null.
Eswar Koneti has a WQL query that gives me just what I'm looking for. Charlie Heavner Systems Administrator Windows Engineering & Domain Services Phone: 336-691-3069 [Description: LFG-B-HORZ_202_K] From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Tuesday, March 18, 2014 11:45 AM To: [email protected] Subject: [mssms] RE: SCCM2012 - Primary User = False This may or may not help you but this is it in SQL. select sys.Name0 [Computer Name], prim.* from v_R_SYSTEM sys LEFT JOIN vUsersPrimaryMachines prim on sys.ResourceID = prim.MachineID LEFT JOIN v_R_USER vru ON vru.ResourceID = prim.UserResourceID where prim.MachineID IS NULL From: [email protected] [mailto:[email protected]] On Behalf Of Krueger, Jeff Sent: Monday, March 17, 2014 4:34 PM To: [email protected] Subject: [mssms] RE: SCCM2012 - Primary User = False I take that back, it doesn't appear that SMS_R_System.IsAssignedToUser value equates to primary user... Don't actually see where that would be stored off hand. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Krueger, Jeff Sent: Monday, March 17, 2014 5:15 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SCCM2012 - Primary User = False 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.IsAssignedToUser is null From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Heavner, Charlie Sent: Monday, March 17, 2014 4:56 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] SCCM2012 - Primary User = False Hi folks, I'm looking for a WQL query to help me find out what workstations do NOT have a Primary User assigned. I've googled until I'm almost blind. The one script that I found didn't work. Anybody got any ideas for me? Thanks, Charlie Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.** ________________________________ CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com<http://www.henryford.com> for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
<<inline: image003.jpg>>
