cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ersoy
Engaged Sweeper
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
3 REPLIES 3
Hemoco
Lansweeper Alumni
Like I said in previous post, most likely you need tblsublicenses now to link and filter to.
Ersoy
Engaged Sweeper
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
Lansweeper Alumni
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now