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
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
Hi,
Thanks for your reply.
I modify the script and it could be for all our client.
SELECT FCM.Name As 'Computer Name', ARP.displayname0 As 'Product Name', Version0 As 'Product Version'
FROM v_Add_Remove_Programs As ARP
JOIN v_FullCollectionMembership As FCM on ARP.ResourceID=FCM.ResourceID
WHERE FCM.CollectionID = 'SMS00001'
GROUP BY DisplayName0, Version0, FCM.Name
ORDER BY [Computer Name] Asc, [Product Name] Asc
Best regards,
Amanda
Hi @raminsa-6505,
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.
Thank you dear Amandayou-MSFT
your script show error syntax
and we need something like this script but for all our client
What is wrong with the built in reports for this?
its return syntax error
SO i'm very new to script and do not know how to troubleshoot.
5 people are following this question.