Share via

SCCM Reports - Create a report that shows all installs of a specific piece of software on all devices, the login used on that device and the device ID

Grant M 1 Reputation point
2022-07-06T08:21:28.517+00:00

Hi all!

I'm being asked to run a report on installations of a specific piece of software on our estate via SCCM. I've found report 02D which has been great for showing the specific devices that this application is installed on, however I'm also being asked for the user ID's associated with these devices. Is there a report that can generate all of this info? Or am I doomed to go through several Excel files and manually entering this? Could CMPivot allow me to get this info?

Many thanks in advance!

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
460 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 5,801 Reputation points
    2022-07-06T10:13:19.03+00:00

    You you need to edit the report and add what you need to it. I would clone it and make you changes too it.

    1 person found this answer helpful.
    0 comments
  2. AllenLiu-MSFT 40,961 Reputation points Microsoft Vendor
    2022-07-07T02:52:29.68+00:00

    Hi, @Grant M

    Thank you for posting in Microsoft Q&A forum.

    You may use this SQL query to get the info, replace the value of DisplayName0 with your software name. 

    select distinct  
v_R_System.Name0,   
v_R_System.ResourceID,   
v_R_System.User_Domain0,  
v_R_System.User_Name0,  
v_Add_Remove_Programs.DisplayName0  
from v_R_System  
inner join v_Add_Remove_Programs  
on v_Add_Remove_Programs.ResourceID = v_R_System.ResourceId  
where DisplayName0 = 'SoftwareName'

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.