Recover All Installed Software Report

[ismith]

Hi,

Whilst trying to create a new report i accidently edited the All Installed Software report and then corrupted it.

Where can i find the original code to recover the report?

I have manage to sort of duplicate it but the links for each piece of software are missing/not working.

Here is my code but i'd much rather have the proper code installed

SELECT DISTINCT
tblSoftware.softwareName,
tblSoftware.SoftwarePublisher,
tblSoftware.softwareVersion,
COUNT(tblSoftware.SoftwareID) AS Total
FROM
tblSoftware
INNER JOIN tblComputers ON (tblSoftware.ComputerName = tblComputers.Computername)
GROUP BY
tblSoftware.softwareName,
tblSoftware.SoftwarePublisher,
tblSoftware.softwareVersion

Thanks for any help

[ismith]

Thank you very much

[Anonymous]

Here it is:

Select Top 100 Percent dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Count(dbo.tblSoftware.ComputerName) As Total From dbo.tblSoftware Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher Order By Count(dbo.tblSoftware.ComputerName) Desc