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
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:
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%'
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
