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.
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.
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.
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.
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…