NagVis / LQL: retrieve hosts or services by wato folder

[Yggy]

Using Checkmk Raw Edition 2.1.0p5, trying to add a dynamic map in NagVis for hosts residing in specific wato folder. NagVis uses ‘simplified’ LQL.
Example dynamic map Services filtered by description with cert in it.

Searched output of columns of Hosts and Services if there is something wato folder map related in them, but not seeing it or it is not clearly described:
lq "GET columns\nFilter: table = hosts\nColumns: name type description"
lq "GET columns\nFilter: table = services\nColumns: name type description"

I can only think of a workaround to get it done.
Add a rule on wato folder(s), to add a label specifying the wato folder to host or service that I want to retrieve in NagVis.

Is it possible without such workaround?

[gstolz (Gerd Stolz)]

The column “host_filename” (which is available in all Livestatus tables I think) includes the folder, using regex, you should be able to filter for the correct folder based on that

[Yggy]

Didn’t realise that the wato folders were physical folders on the server as well.

Thanks!