Custom Report for .net Versions

[Kay]

Hello friends,

i need a Custom Report to see which .net Framwork Version ist installed on which PC (with Name) 

in the Forum i found a Custom Report for seeing all the .net Versions installed but i need to see which PC has which Version installed.

can someone help me writing this?

thanks for every help!

Kay

[Hendrik_VE · Accepted solution]

We use the following report (requires the registry key HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full ; Value = Release to be scanned):

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tsysOS.OSname As OS,
  tblAssets.SP,
  Case
    When NETVersion.Value = '378389' Then '.NET 4.5'
    When NETVersion.Value = '378675' Then '.NET 4.5.1'
    When NETVersion.Value = '378758' Then '.NET 4.5.1'
    When NETVersion.Value = '379893' Then '.NET 4.5.2'
    When NETVersion.Value = '393295' Then '.NET 4.6'
    When NETVersion.Value = '393297' Then '.NET 4.6'
    When NETVersion.Value = '394254' Then '.NET 4.6.1'
    When NETVersion.Value = '394271' Then '.NET 4.6.1'
    When NETVersion.Value = '394802' Then '.NET 4.6.2'
    When NETVersion.Value = '394806' Then '.NET 4.6.2'
    When NETVersion.Value = '460798' Then '.NET 4.7'
    When NETVersion.Value = '460805' Then '.NET 4.7'
    When NETVersion.Value = '461308' Then '.NET 4.7.1'
    When NETVersion.Value = '461310' Then '.NET 4.7.1'
    When NETVersion.Value = '461808' Then '.NET 4.7.2'
    When NETVersion.Value = '461814' Then '.NET 4.7.2'
    When NETVersion.Value = '528040' Then '.NET 4.8'
    When NETVersion.Value = '528049' Then '.NET 4.8'
    When NETVersion.Value = '528372' Then '.NET 4.8'
    When NETVersion.Value = '528449' Then '.NET 4.8'
    When NETVersion.Value = '533325' Then '.NET 4.8.1'
    Else 'Older Version'
  End As [.NET Version],
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join (Select tblRegistry.Value,
        tblRegistry.AssetID
      From tblRegistry
      Where tblRegistry.Valuename = 'Release' And tblRegistry.Regkey =
        'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full')
  NETVersion On tblAssets.AssetID = NETVersion.AssetID
Where tblAssetCustom.State = 1
Order By 
  tblAssets.AssetName

[Kay]

Thanks Mate, this really helped me. appreciate your Work!