List Machines with Multiple Software Versions with asset name filter?

[fpino]

Hello.
I found the query for list List Machines with Multiple Software Versions (url) but how can i modify the query to assets with specific pattern name ?.
thanks you

[Susan_A · Accepted solution]

I would recommend familiarizing yourself with SQL, and SQL operators in particular, to get a better understanding of how filtering works. The Lansweeper report builder is a standard SQL editor. Adding the following (standard SQL syntax) to the Criteria column of the tblAssets.AssetName expression will return any asset whose name contains the word "LAN" for instance:

Like '%lan%'