Software Overview of Servers

[FCF_IT]

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

[Hemoco]

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,
tblSoftware.SoftwarePublisher
From tblSoftware Inner Join
tblComputersystem On tblComputersystem.Computername =
tblSoftware.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 =
tblSoftware.SoftwarePublisher
Where tblComputersystem.Domainrole > 1
Order By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblComputers.ComputerUnique

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.