I broke the report for “All installed software”

[xris]

Hello, I was in Lansweeper Report Builder, checking how the Report for “All installed software” works.
I was using Edit Report to start making my own query around it, and saved my query over the top by mistake. I have since rolled back what I did, by undoing my changes (to the best of my understanding of what it was before). The Report does pop out all the software installed on the network (I think it might be missing a count listed, to how many counts of that software is installed).

The thing is thou, is that on the Lansweeper Web Console, when I bring up the “All installed software” Report, none of the listed software is hyperlinked like it was before. So obviously I’ve not put the query back the way it was before.

default.aspx?item=cust&det=web30repsoftwaretotal&title=All+installed+software

Is the page its loads on.

Is there any chance I can grab a copy of the default query to cut and paste back in there?
Or should I look at restoring the db from a fresh install?

[xris]

Thank you very much, the URL's now work.

[Hemoco]

This is the original sql :

SELECT     TOP 1000000 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