SQL Select Statement to find objects by their color

Yasushi_Kono1 — Thu, 23 May 2019 18:16:47 GMT

Hi there,

I am curious on whether it is possible to query objects by their attributes which are not part of their column? For instance, if I wanted to have a list of host objects that are all green, how could I accomplish this task?

The following syntax does not work:

select name from dleobjectderef_data where objectoverview like ‘GREEN‘;

Thanks a lot in advance.

Kind regards,

Yasushi

Re: SQL Select Statement to find objects by their color

PhoneBoy — Fri, 24 May 2019 17:01:08 GMT

Direct access to the database is NOT supported, nor is it necessarily logged/audited.
This should be done with the API, which I believe you could do with a combination of mgmt_cli and jq.

topic Re: SQL Select Statement to find objects by their color in Firewall and Security Management

SQL Select Statement to find objects by their color

Re: SQL Select Statement to find objects by their color