Menu
CCMEXEC.COM – Enterprise Mobility
  • General
  • Configuration Manager
  • Windows 10
  • Windows 11
  • Intune
  • GitHub
  • About
CCMEXEC.COM – Enterprise Mobility

SCCM Report Installed application per subnet

Posted on May 3, 2012 by Jörgen Nilsson

Wrote this as an answer to a Technet forum question, it will list all Microsoft Office applications for a specific subnet. It can easily be changed to filter on more than one subnet and different applications.

select ip.IP_Subnets0 [Subnet], sys.Name0 [Name], DisplayName0
from v_R_System sys
join v_RA_System_IPSubnets ip on ip.ResourceID = sys.ResourceID join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID =  sys.ResourceID
Where IP_Subnets0 = '192.168.1.0' and Displayname0 like 'Microsoft Office%'
order by ip.IP_Subnets0, sys.Name0

select ip.IP_Subnets0 [Subnet], sys.Name0 [Name], DisplayName0

from v_R_System sys

join v_RA_System_IPSubnets ip on ip.ResourceID = sys.ResourceID join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID =  sys.ResourceID

Where IP_Subnets0 = '192.168.1.0' and Displayname0 like 'Microsoft Office%'

order by ip.IP_Subnets0, sys.Name0

1 thought on “SCCM Report Installed application per subnet”

  1. Kev says:
    June 4, 2015 at 12:08 pm

    Code works sweet on single applications but if I wanted to list all the applications installed per Subnet would there be a way to combine each instance of an application/install?

    Then be able to expand, or click on application, to show the machine names.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

My name is Jörgen Nilsson and I work as a Senior Consultant at Onevinn in Malmö, Sweden. This is my blog where I will share tips and stuff for my own and everyone elses use on Enterprise Mobility and Windows related topics.
All code is provided "AS-IS" with no warranties.

Recent Posts

  • Windows 365 Link – a week and some
  • Prevent software installations disguised as drivers
  • Tip when troubleshooting unexpected reboots during Autopilot – event ID 2800
  • New settings in Intune Security Baseline Windows 11 24H2 -2504
  • Managing extensions in Visual Studio Code
©2025 CCMEXEC.COM – Enterprise Mobility | WordPress Theme by Superb Themes
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT