Entity status table in New Relic

how to check status of entities? Is there any table which we can use to see the entity status in newrelic?

Hi, @ajay.kumar4: You will need to be more specific: what type(s) of entities: Applications? Hosts? And what do you mean by “status”?

what type(s) of entities: Applications? Hosts? And what do you mean by “status”?

Answer: entities like application, hosts, container etc. and status is like there is green or red or yellow.

we wanted show the entity status from workload in a custom dashboard.

we were looking table for entity status if u can help.

Okay. New Relic does not expose “tables”, it exposes metrics and events. An entity‘s health status (green, yellow, red) is determined by whether it has any open alert violations. You may query the NrAiIncident event to get a list of incidents for an entity:

SELECT count(*) 
FROM NrAiIncident 
WHERE event = 'open' 
  AND entity.name = 'entity name' 
FACET priority

Priority warning is yellow; critical is red. I do not know of a way to get a list of incidents that are currently open. That question has been asked many times without a satisfactory solution.

1 Like