cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
teejayuu
Engaged Sweeper
Hi

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

Thanks
Tony
Tony In view of the fact that God limited the intelligence of man, it seems unfair that He did not also limit his stupidity. Konrad Adenauer
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

2 REPLIES 2
teejayuu
Engaged Sweeper
Thanks
Tony In view of the fact that God limited the intelligence of man, it seems unfair that He did not also limit his stupidity. Konrad Adenauer
Hemoco
Lansweeper Alumni
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now