→ 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: 
fpino
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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%'

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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%'