Author: Nawaz
Welcome to our blog, where we embark on a fascinating exploration of the SCCM Cmpivot tool and uncover valuable insights about the .NET Framework versions installed on machines in your collection.
As we delve into the depths of the Windows Registry, our quest leads us to a specific key: “HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full”. Within this hidden realm, we discover a treasure trove of information about the installed .NET Framework versions.
HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
While traversing the registry manifests, we encounter a captivating enigma. The desired details, such as “.NET Framework Version 4.8” and the newly found “.NET Framework Version 8.1”, may not be readily apparent. However, fear not, for we have unlocked the secrets to deciphering these generic names through insightful blog entries.
Armed with this knowledge, we enhance our CMPIVOT query, unveiling a wealth of relevant information. With the powerful case() scalar function by our side, we evaluate a series of conditions and retrieve the first expression that satisfies the criteria. This versatile function, reminiscent of the case function in SQL queries, adds depth and efficiency to our data exploration.
Operatingsystem | project device, Caption | join (Registry('HKLM:\SOFTWARE\Microsoft\Net framework Setup\NDP\v4\Full') | where Property == 'Release' ) | project device,caption,key,value, case ( value == '528372','.Net frameWork 4.8', value == '378389','.NET Framework 4.5', value == '378675','.NET Framework 4.5.1', value == '378758','.NET Framework 4.5.1', value == '379893','.NET Framework 4.5.2', value == '393295','.NET Framework 4.6', value == '393297','.NET Framework 4.6', value == '394254','.NET Framework 4.6.1', value == '394271','.NET Framework 4.6.1', value == '394294','.NET Framework 4.6.1', value == '394802','.NET Framework 4.6.2', value == '394806','.NET Framework 4.6.2', value == '460798','.NET Framework 4.7', value == '460805','.NET Framework 4.7', value == '461308','.NET Framework 4.7.1', value == '461310','.NET Framework 4.7.1', value == '461808','.NET Framework 4.7.2', value == '461814','.NET Framework 4.7.2', value == '528040','.NET Framework 4.8', value == '528049','.NET Framework 4.8', value == '528372','.NET Framework 4.8', value == '533325','.NET Framework 4.8.1', 'Need to Know Which .Net Version' )
Result
As we conclude this post, I encourage you to embrace the excitement of your SCCM Cmpivot adventures.
Goodbye, for now, fellow adventurers! We’ll meet again on our quest for knowledge and uncover the mysteries of the SCCM, Intune, CMPivot.
Brilliant stuff
I will share with colleagues
Hi Nawaz,
getting the following error
Failed to resolve entity ‘key’