Microsoft Office 2010 Report

[jpv]

Hello,

Can someone help with a report that will only show all instances of the following products running in our environment? I would also like to exclude machines with certain hostnames if possible. For instance, all hostnames that being with DELL12345.


Microsoft Office Professional Plus 2010
Microsoft Office Standard 2010

Thanks in advance!

[jpv]

Thank you! That worked.

[Hemoco · Accepted solution]

You can modify the built-in report "Software: List of software by computer" under Reports/View All Reports.

Add the below to the Criteria column for the tblSoftwareUni.softwareName expression.

= 'Microsoft Office Professional Plus 2010' or = 'Microsoft Office Standard 2010'

To exclude machines based on asset name, replace the tblAssets.AssetUnique expression with tblAssets.AssetName and add the below to the Criteria column.

Not Like 'DELL12345%'

For future reporting, we would recommend reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries and what you are asking is a basic SQL thing. There are several good tutorials available online, e.g.: http://www.w3schools.com/sql/default.asp