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]> 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. > >
