Thanks Eswar. I actually found your blog post a few weeks back and I have that set up and use often. I’m really looking for the reverse though. A query that’ll show me all users without a primary device assigned. Is that possible?
From: [email protected] [mailto:[email protected]] On Behalf Of Eswar Koneti Sent: Thursday, October 30, 2014 11:19 AM To: [email protected] Subject: RE: [mssms] Users w/o assigned device query Something like this? http://eskonr.com/2014/03/sccm-configmgr-2012-collection-for-computers-with-primary-user-uda-is-null/ Regards, Eswar Koneti www.eskonr.com<http://www.eskonr.com> Sent from Mobile Device, excuse any typo's as a result. --- Original Message --- From: "Beardsley, James" <[email protected]<mailto:[email protected]>> Sent: October 30, 2014 11:12 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] Users w/o assigned device query Hello all. I’m looking to build a SQL query (or WQL) that will return all users without a primary device assigned. Any ideas? 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.
