We need to have an alert on all VMhost which are not polled.. Below command will the result.. select hostname from VIM_hosts where ManagedStatusMessage is not NULL order by hostname But how can we apply this in Advanced alert manager. In custom SQL queries also, we are not able to find a selection which will pull info form the table VIM_hosts.
I would also like to alert on VIM_Hosts table. Actually I would like to alert on any table. Please open up the Select section of the SQL table.