Page 1 of 1

[SOLVED] Console - Inventory - How to filter with an SQL query

Published: July 10, 2023 - 5:36 PM
by Regis Lemonnier
Hello,

how can I use an SQL query to filter the machine inventory with WAPT 2.2.1.1957?
The "Filter with SQL query" field only offers "none" as a choice, yet I have many SQL queries in "Reporting".

Re: Console - Inventory - How to filter with an SQL query

Published: July 10, 2023 - 6:23 PM
by htouvet
Hello,
the queries must be designed so that one of the columns represents the machine's UUID.
In the query builder, run the query and right-click on a cell representing a machine UUID.
Then click "Select as Host UUID"
and save the query.
The query will then be available as a filter in the global inventory.