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
Query listing primary user and the primary device
July 26th, 2013 5:49pm
When I try to import that query in Config Manager I get a syntax error. I'm sorry if I'm completely doing it incorrectly - I don't come from an SMS or SCCM background.
July 26th, 2013 8:13pm
That's a SQL query that should be executed in SQL management studio. It can also be used to create a SRS report.
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2013 8:21pm
That's a SQL query that should be executed in SQL management studio. It can also be used to create a SRS re
March 20th, 2014 6:44am
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
Free Windows Admin Tool Kit Click here and download it now
May 7th, 2015 1:03pm