Please contact us at support@lansweeper.com and provide us with the following:
- Screenshot of your web console landing page. You can access your landing page by clicking on the Lansweeper logo in the top left corner of the web console. Please show us
the whole page.
- Output of the report below, preferably in Excel format.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblCompCustom.State, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged, tblSoftwareHist.softwareName As softwareName1,
tblSoftwareHist.softwareVersion As softwareVersion1,
tblSoftwareHist.SoftwarePublisher As SoftwarePublisher1,
tblSoftwareHist.Installdate As Installdate1, tblSoftwareHist.Lastchanged As
Lastchanged1, tblSoftwareHist.Action
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
tblSoftwareHist On tblComputers.Computername = tblSoftwareHist.ComputerName
Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Where tblSoftware.softwareName Like '%map%' And
tblSoftwareHist.softwareName Like '%map%'
Order By 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.