question

raminsa-6505 avatar image
0 Votes"
raminsa-6505 asked raminsa-6505 answered

all installed application on all client



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

mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered Amandayou-MSFT converted comment to answer

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.

131506-9131.png

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.



9131.png (13.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you dear Amandayou-MSFT

your script show error syntax

and we need something like this script but for all our client

0 Votes 0 ·
Garth avatar image
0 Votes"
Garth answered Garth commented

What is wrong with the built in reports for this?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

its return syntax error

SO i'm very new to script and do not know how to troubleshoot.

0 Votes 0 ·

Exactly what error did you get with the built in reports?

0 Votes 0 ·
raminsa-6505 avatar image
0 Votes"
raminsa-6505 answered

Thank you dear Amandayou-MSFT

you resolve our issue

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.