fetch particular software installed.

Question

Hi all i have a collection which has 250 servers. i am looking for a list of servers on which a particular software lets say abc is installed using sccm. will the below query fetch me.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on 
SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like 'abc%'

Answer 1

Hi @Rising Flight

Thank you for posting in Microsoft Q&A forum.

1,Agree with @Rahul Jindal [MVP] . You can use below built-in report under the Asset Intelligence category to list the devices with specified software installed:

Software 02D - Computers with specific software installed

2,You can also refer to below guides to list the devices with a particular software installed:

SCCM Collection Query for Devices with specific software installed and version or below [2023 Updated]

How to create a collection of computers by installed software.

SCCM report applications installed on computers without Updates

Thanks for your time. Have a nice day!

Best regards,

Simon

---

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.