SQL Select Statement to find objects by their color

[Yasushi_Kono1]

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

[PhoneBoy]

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.