All Versions of .NetFramework

[mmeetze]

.Net Framework can be searched for so I know that it is available but under the built in reports there seems to be just targeted versions for the reporting. I was curious if anyone had built a report that would include ALL versions of .Net Framework in their environment?

[mmeetze]

Thanks, would there be a way to display these in one report without the hyperlinks to each version?

[Esben_D]

You can create this report by using the built-in report "Software: All Microsoft software", removing the criteria from SoftwarePublisher and adding the following criteria on SoftwareName: Like 'Microsoft .NET Framework%'

I added the report below for your convenience.

Select Top 1000000 tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  Count(tblSoftware.SoftwareID) As Total
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion
Having tblSoftwareUni.softwareName Like 'Microsoft .NET Framework%'
Order By Total Desc,
  Software