→ 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: 
jpv
Engaged Sweeper
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!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
jpv
Engaged Sweeper
Thank you! That worked.
Hemoco
Lansweeper Alumni
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