cancel
Showing results for 
Search instead for 
Did you mean: 
Post a Question
Highlighted

SQL Select Statement to find objects by their color

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

0 Kudos
1 Reply
Admin
Admin

Re: SQL Select Statement to find objects by their color

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.
0 Kudos