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

Kai Lantiegne 1 Reputation point
2022-05-03T15:53:15.117+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,855 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. T. Kujala 8,706 Reputation points
    2022-05-03T16:35:28.707+00:00
    1 person found this answer helpful.
    0 comments
  2. Amandayou-MSFT 11,056 Reputation points
    2022-05-04T06:38:32.36+00:00

    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.

    1 person found this answer helpful.