All installed software - missing links

[airdih]

HI!

I recently messed up my softwaretotal report. I was trying to exclude all software with "hotfix" in its name. Since then, my report is missing "softDetail" links for each software and i can't see who has a particular software installed...

How can i get this back?

Thanks

[airdih]

Problem solved!

Thanks for your help

[Hemoco]

Most likely you have deleted the whole report.

Change the alter to create:

create view web30repsoftwaretotal as 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

[airdih]

if i execute this script from the console it says: Invalid object name 'web30repsoftwaretotal'

[Hemoco]

You don't need to save this as a report.
You need to run this as a sql script from the configuration utility.

[airdih]

Incorrect syntax near 'AS'

That's what it says when trying to save this reprot...

[Hemoco]

try this :

alter view web30repsoftwaretotal as 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