get all installed application name report

Question

Hi dear expert

we need report to get all installed application name on all client in our enterprise

whether installed via SCCM or via User

please let me know in detail

Thank you in advance

Answer 1

You will not be able to track if the application is installed by user or ConfigMgr unless you add tag or something for all apps that are installed from Configmgr.
For the list of all apps , you can use the default configmgr reports (there are many) to export the apps list for further checking.
If you are looking for all installed apps on all clients, refer to this why you shouldnt do this. https://www.recastsoftware.com/resources/how-to-perform-a-basic-software-audit-2/

Thanks,
Eswar

Answer 2

Hi @ramin sa ,

What we using could be the SCCM report Software 02E - installed software on a specific computer. But it have to run the report on each PC, so it is very time consuming.

We could use the following sql query, and access the installed software of computers that are discovered by SCCM.

DECLARE @CollID AS VARCHAR(8);  
  
SET @CollID = ‘SMS00001’  
SELECT  DisplayName0 As ‘Product Name’, Version0 As ‘Product Version’, FCM.Name As ‘Computer Name’  
  
FROM  v_Add_Remove_Programs As ARP   
  
JOIN v_FullCollectionMembership As FCM on ARP.ResourceID=FCM.ResourceID    
  
WHERE  FCM.CollectionID = @CollID   
  
GROUP BY DisplayName0, Version0, FCM.Name  
  
ORDER BY DisplayName0 Asc, Version0 Asc   

Here is the article we could refer to:
https://bestitsm.wordpress.com/2018/06/29/list-software-inventory-items-of-computers-discovered-by-sccm/
Note: Non-Microsoft link, just for the reference.

---

If the response is helpful, please click "Accept Answer" and upvote it.
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.

Answer 3

What is wrong with the built in reports for this?