
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-04-2017 08:50 PM
.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?
Labels:
- Labels:
-
Report Center
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-05-2017 03:25 PM
Thanks, would there be a way to display these in one report without the hyperlinks to each version?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-05-2017 11:46 AM
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.
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
