Add Custom query resource:
and Add this to that resource:
select S.ShortDescription as Status, count(N.status) as number from Orion.nodes as N
left join Orion.StatusInfo as S on S.Statusid=N.Status
group by S.ShortDescription
Probably someone can tune this.
Hey thanks for that. Exactly what I was looking for.
can somebody help me in applying filter using custom property named Entity. As My manager want three different list differentiated using Entity name
Also how add total no. in this
How can I do the same but for a specified group of nodes only, not all the nodes?
And can we graphic that per week or so?