neo4j health summary

Neo4j Health Summary.cyp

with summary as (
  select
    r.QueryId,
    r.QueryTime,
    r.Result,
    row_number() over (partition by r.QueryId order by r.QueryTime desc) as rk
  from vr_t_Neo4jHealthResult r
)
select
  s.QueryId,
  s.QueryTime,
  q.Comment,
  s.Result,
  case q.Severity
    when 0 then 'Stats'
    when 1 then 'Warning'
    when 2 then 'Critical'
  end
from
  summary s
inner join vr_t_Neo4jHealthQuery q
  on q.QueryId = s.QueryId
where
  s.rk = 1
order by 
  q.Severity desc