I created a new report in Report Builder to show me all the version of Symantec Anti-Virus and the Definition Date based on the software table and the registry table after collecting the registry information.
Here is the sql for the report.
Select Distinct Top (100) Percent dbo.tblComputers.Computername As Computer, dbo.tblOperatingsystem.Description, dbo.tblOperatingsystem.Caption As [Operating System], dbo.tblComputers.Domain, dbo.tblSoftware.softwareName As [Software Release], dbo.tblSoftware.softwareVersion As Version, Right(dbo.tblregistry.Value, 12) As [Def Date]
From dbo.tblComputers Inner Join dbo.tblComputersystem On dbo.tblComputers.Computername = dbo.tblComputersystem.Computername Inner Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername Left Outer Join dbo.tblSoftware On dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName Left Outer Join dbo.tblregistry On dbo.tblComputers.Computername = dbo.tblregistry.Computername And dbo.tblregistry.Valuename = 'DEFWATCH_10'
Where dbo.tblSoftware.softwareName Like 'Symantec% Endpoint Protection' Or dbo.tblSoftware.softwareName Like 'Symantec% AntiVirus' Or dbo.tblSoftware.softwareName Like 'Symantec Client Security' Or dbo.tblSoftware.softwareName Like 'Norton AntiVirus Corporate Edition'
Order By Computer
Issue I am having is that the report run fine within Report Builder but not on the web console. I added it to the software reports tab and it shows the number of machine and the % of machine but when I click the link I get a run time error.
I have attached screenshots.