Create a report in SCCM to query machines without a specific software

Question

I am needing to create a report to all machines WITHOUT Microsoft Edge installed.

I am fairly novice with SCCM and not a SQL guy. I'd like to use the creation wizard in SCCM and report builder, but I get lost.
Ideally we would like to be able to filter it to certain collections within SCCM. Any advice?

Answer 1

Hi @Kai Lantiegne ,

Hopefully, this helps you.

SCCM: How to create a collection for computers without a specific software installed.

Answer 2

Hi @Kai Lantiegne ,

Besides the method above, we could run the following WQL, please put it in the query rule:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.Client, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "XYZAPP")  

Note: above is query that does not include appname xyzapp.

Maybe we need not to create report, just run it in the collection, and we will get the result we want.

---

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.