Laptops with version of particular software

[teejayuu]

Hi

Can someone help me write a report that shows the version number of MS Office on just laptops?

Thanks
Tony

[teejayuu]

Thanks

[Hemoco · Accepted solution]

Please try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysChassisTypes.ChassisName, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where TsysChassisTypes.ChassisName = 'laptop' And tblSoftware.softwareName Like
'%office%'
Order By tblComputers.ComputerUnique, tblSoftware.softwareName

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.