Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Is it possible to create a new report such as the Software Overview one that only shows software installed on servers?

So OS would be "Windows Server ..." or maybe via a description in AD where it starts with "Server - Description of role"

Thanks in advance
Lansweeper Alumni
We would recommend including server names in your report. If you were to generate a report similar to the Software Overview, you would not be able to link the software names to the names of just servers who have that software installed.

Please try the report below.
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Description, tblComputers.Firstseen, tblComputers.Lastseen,
tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Lastchanged,
SoftwareCount.[Total Installations]
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
(Select Count(tblSoftware.ComputerName) As [Total Installations],
tblSoftware.softwareName, tblSoftware.softwareVersion,
From tblSoftware Inner Join
tblComputersystem On tblComputersystem.Computername =
Where tblComputersystem.Domainrole > 1
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher) SoftwareCount On SoftwareCount.softwareName
= tblSoftware.softwareName And SoftwareCount.softwareVersion =
tblSoftware.softwareVersion And SoftwareCount.SoftwarePublisher =
Where tblComputersystem.Domainrole > 1
Order By tblSoftware.softwareName, tblSoftware.softwareVersion,

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.