→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
infoscreen
Engaged Sweeper II
Hi,
is it possible to generate a report based on "List of software by computer" where OS is also listed as Software?

thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please use the report below for the information you are after.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername,
tblComputers.Domain, tblComputers.Computer, tblComputers.Firstseen,
tblComputers.Lastseen, SoftwareAndOS.Type, SoftwareAndOS.Name,
SoftwareAndOS.Version, SoftwareAndOS.Publisher
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
(Select tblSoftware.ComputerName, 'Software' As Type, tblSoftware.softwareName
As Name, tblSoftware.softwareVersion As Version,
tblSoftware.SoftwarePublisher As Publisher
From tblSoftware
Union
Select Web40OSName.Computername, 'OS' As Type, Web40OSName.OSname As Name,
Web40OSName.OScode As Version, Case Web40OSName.OSname
When 'Not scanned' Then 'Not scanned' Else 'Microsoft Corporation'
End As Publisher
From Web40OSName) SoftwareAndOS On SoftwareAndOS.ComputerName =
tblComputers.Computername
Order By tblComputers.ComputerUnique, SoftwareAndOS.Type, SoftwareAndOS.Name,
SoftwareAndOS.Version

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.

View solution in original post

2 REPLIES 2
infoscreen
Engaged Sweeper II
Thank you very much for your excellent support
Hemoco
Lansweeper Alumni
Please use the report below for the information you are after.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername,
tblComputers.Domain, tblComputers.Computer, tblComputers.Firstseen,
tblComputers.Lastseen, SoftwareAndOS.Type, SoftwareAndOS.Name,
SoftwareAndOS.Version, SoftwareAndOS.Publisher
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
(Select tblSoftware.ComputerName, 'Software' As Type, tblSoftware.softwareName
As Name, tblSoftware.softwareVersion As Version,
tblSoftware.SoftwarePublisher As Publisher
From tblSoftware
Union
Select Web40OSName.Computername, 'OS' As Type, Web40OSName.OSname As Name,
Web40OSName.OScode As Version, Case Web40OSName.OSname
When 'Not scanned' Then 'Not scanned' Else 'Microsoft Corporation'
End As Publisher
From Web40OSName) SoftwareAndOS On SoftwareAndOS.ComputerName =
tblComputers.Computername
Order By tblComputers.ComputerUnique, SoftwareAndOS.Type, SoftwareAndOS.Name,
SoftwareAndOS.Version

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.