Is there a query to list the primary device and the primary user associated with that device. Coming from a LANDesk environment I was able to create reports and queries that would list this information pretty easily. I can't seem to link the two in SCCM for reporting. Thanks 

That's a SQL query that should be executed in SQL management studio. It can also be used to create a SRS re

Below is the SQL query from Torsten's link (I added the last line).  Unfortunately it returns multiple UserResourceIDs for each MachineID.  Is there a variation of this that will return ONE true PRIMARY user for each device?

select
 upm.UserResourceID,
 upm.MachineID,
 vru.Name0 as [User Name],
 vrs.Name0 as [Machine Name]
 from
 v_UsersPrimaryMachines upm
 left join v_R_User vru
 on upm.UserResourceID = vru.ResourceID
 left join v_R_System vrs
 on upm.MachineID = vrs.ResourceID
 order by vrs.Name0