My report does not work on new version of Lansweeper

[Ersoy]

I had a report which worked before I upgraded to the new version of Lanseeper but now it does not work. Looks like the new version has changed the tables. Below is the report from report builder and this is the error I get when I run the report >> "Report has an invalid syntax: Invalid column name 'softwareVersion'. ". Is there a fix or workaround?


Select Distinct Top 100 Percent dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, dbo.tblSoftware.SoftwarePublisher, Count(dbo.tblSoftware.ComputerName) As Count From dbo.tblSoftware Inner Join tblLicenses On tblLicenses.softwareName = dbo.tblSoftware.softwareName And tblLicenses.softwareVersion = dbo.tblSoftware.softwareVersion Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher Having dbo.tblSoftware.SoftwarePublisher Like '%microsoft%' And Count(dbo.tblSoftware.ComputerName) > 0 Order By dbo.tblSoftware.softwareName

[Hemoco]

Like I said in previous post, most likely you need tblsublicenses now to link and filter to.

[Ersoy]

The output of that only shows "Microsoft Exchange", Microsoft SQL Server 2005" and "Microsoft SQL Server 2008" and that's it. What about all the other microsoft software?

[Hemoco]

Select Distinct Top 1000000 dbo.tblSoftware.softwareName As Software,
  dbo.tblSoftware.softwareVersion As Version, dbo.tblSoftware.SoftwarePublisher,
  Count(dbo.tblSoftware.ComputerName) As Count
From dbo.tblSoftware Inner Join         
  tblLicenses On tblLicenses.softwareName = dbo.tblSoftware.softwareName
Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion,
  dbo.tblSoftware.SoftwarePublisher
Having dbo.tblSoftware.SoftwarePublisher Like '%microsoft%' And
  Count(dbo.tblSoftware.ComputerName) > 0
Order By dbo.tblSoftware.softwareName

You can start from here but most likely you need to add table tblsublicenses and link this table to table software.