SCCM Report for DotNet Framework Versions

Let’s check the options to find out the SCCM report for DotNet Framework version details. The >net version is important for the latest versions of SCCM. The SCCM servers should have DotNet 4.8. This is the recommended version for SCCM 2107.

You have a list of SCCM default reports available, and those are ready to use. However, you have to build some custom reports that are very specific to your organizational needs. The requirement of DotNet framework reports from SCCM is the special one because of the latest recommendations from Microsoft.

Windows 10 DotNet Framework Reports

It’s not easy to get the DotNet framework report from Windows 10 device! This is because the .NET Framework entries are not visible in Add Remove Programs for Windows 10 PCs. So what is the way to get the .NET Framework reports for Windows 10?

The best way is to use SCCM Configuration Item (CI) to collect the DotNet framework version details from Windows 10 and Windows 11 PCs. I think you can check the registry entry verification or script method to get these details. Another option is to use a custom MOF file to get DOTNET framework details.

Patch My PC
Windows 10 - SCCM Report for DotNet Framework Versions
Windows 10 – SCCM Report for DotNet Framework Versions

DotNet Framework Version Report for Server Operating System

The option to create a DotNet Framework report for server operating systems like Server 2012, Server 2016, etc.. is more straightforward. You can use add remove programs view from the SQL database to collect these details using SCCM.

SCCM Report for DotNet Framework Versions
Server OS – SCCM Report for DotNet Framework Versions

You can easily create a Custom SCCM Report for the .Net Framework version using the following query. You can refer to Create Custom Report Using Report Builder. Let’s check how to use SQL management studio to get this report.

  • Open the SQL Management Studio.
  • Connect your Database Engine.
  • Right Click on your database CM_XXX and click on ‘New Query’
  • Copy the following SQL query to find the report of DotNet details.
  • Click on the Execute button.
SCCM Report for DotNet Framework Versions
SCCM Report for DotNet Framework Versions

It would help if you used SQL Management studio to run the following SQL query to find DotNet Framework versions installed on the servers. The following SQL query provides the details like Server Name, Location pf the server based on AD Site, AD Domain details, etc.…

NOTE! – I have a weird issue with WordPress that it’s not allowing me to post SQL queries into code format. Hence I ended up sharing the query in the GitHub repository.

Adaptiva
SCCM Report for DotNet Framework Versions
SCCM Report for DotNet Framework Versions

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

3 thoughts on “SCCM Report for DotNet Framework Versions”

  1. Hello,

    I have Microsoft .Net 4.7 installed on a Windows Server 2019 (seen in Add Features as installed) but I do not see it in Add Remove Programs. Any idea?

    Thanks,
    Dom

    Reply
  2. Hello,

    I found the PowerShell commands for this now looking how to integrate it in a query or report within SCCM.
    (Get-ItemProperty “HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full”).Release
    (Get-ItemProperty “HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full”).Version

    Thanks,
    Dom

    Reply
  3. I have built the following query:
    select distinct SMS_R_System.Name, SMS_R_System.FullDomainName, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.IPAddresses, SMS_G_System_DotNETFrameworks.BuildNumber, SMS_R_System.Build, SMS_R_System.BuildExt from SMS_R_System inner join SMS_G_System_DotNETFrameworks on SMS_G_System_DotNETFrameworks.ResourceID = SMS_R_System.ResourceId where SMS_G_System_DotNETFrameworks.BuildNumber like “4.%” order by SMS_R_System.Name

    Reply

Leave a Comment

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