web30repneverscanned Report error - All installed software

[it2admin]

Hi there,

I tried to be a bit clever and edit the 'all installed software' report without backing it up first and am now receiving this error.

Could you please repost the original SQL that I can use in the Report Builder to create it again.

Thanks 🙂

[Hemoco]

This should be it:

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

[it2admin]

Sorry the error message was actually:

Invalid object name 'web30repsoftwaretotal'