Modern Dashboard monthly figures

N1cko

Hi all,

I'm trying to put together a Modern dashboard showing the top ten servers by average CPU usage, memory usage and volume usage.

I found the entity Cortex.Orion.Node.MemoryMetrics, which, on the graphical builder, allows you to choose the time period, which is great. However, when i try to use it I always get the following error (this is the same for the CPU metric too).

RunQuery failed, check fault information. Entity Cortex.Orion.Node.MemoryMetrics does not contain requested property DateTime

I'm wondering, if this entity doesn't have the DateTime property why does it give me the option to change the time period?

Also, is there another way to get the average CPU\memory usage of a server over the last 30 days?

Many thanks

Nick

KMSigma.SWI

The Coretex entities are mostly used for internal workings and rarely give you want you want.  You'll probably want the <span class="s11" style="font-family:inherit;">Orion</span><span class="s10" style="font-family:inherit;">.</span>CPULoad entity.

SELECT AVG([CPU].AvgPercentMemoryUsed) AS [AvgMem%]
, [CPU].Node.Caption
, DATETRUNC('month', [CPU].ObservationTimestamp) AS [Month]
FROM Orion.CPULoad AS [CPU]
GROUP BY DATETRUNC('month', [CPU].ObservationTimestamp)
, [CPU].Node.Caption