That works. Thanks Ryan! From: [email protected] [mailto:[email protected]] On Behalf Of Ryan Sent: Thursday, October 30, 2014 3:28 PM To: [email protected] Subject: Re: [mssms] Users w/o assigned device query
Try this in WQL: Select * From SMS_R_User where UniqueUserName not in (Select UniqueUserName from SMS_UserMachineRelationship) On Thu, Oct 30, 2014 at 10:09 AM, Beardsley, James <[email protected]<mailto:[email protected]>> wrote: 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.
