Create a Post
cancel
Showing results for 
Search instead for 
Did you mean: 
Yasushi_Kono1
Contributor
Contributor

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
PhoneBoy
Admin
Admin

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

Leaderboard

Epsum factorial non deposit quid pro quo hic escorol.

Upcoming Events

    CheckMates Events