Nevermind, I found it. For anyone interested http://eskonr.com/2014/03/sccm-configmgr-2012-collection-for-computers-with-primary-user-uda-is-null/
From: [email protected] [mailto:[email protected]] On Behalf Of Beardsley, James Sent: Thursday, September 04, 2014 7:07 PM To: [email protected] Subject: [mssms] WQL Query Help I'm looking to create a collection with PC's that have at least one primary user assigned. Is this possible with WQL? If not with WQL, how about SQL? I've got a SQL query that shows me all PC's and the associated primary user and the source, but I can't seem to get the reverse of that. Thanks, James ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation.
