While not the exact SQL you want, it should be a good start. select Users.Name0 as "User Name", SYS.Name0 as "Machine Name" from v_UsersPrimaryMachines UPM left join v_R_User Users on UPM.UserResourceID = Users.ResourceID left join v_R_System SYS on UPM.MachineID = SYS.ResourceID
>From here you have a list of all Primary Devices assigned to everyone. All >clients not in this list are ones without a primary user attached in SCCM. I >don't know how this isn't a standard report out of the box. Seems like a >pretty common report. From: [email protected] [mailto:[email protected]] On Behalf Of Beardsley, James Sent: Thursday, October 30, 2014 11:10 AM To: [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.
