Hi everyone,
I am looking for a SQL script to run a report in the report writer for Average CPU and Memory Percent Utilization-business hours during week days. Does anyone has something they can share?
Thank you
You don't need an Advanced sql report for this. Simply add report filters on the date time field.
I am using NPM 10.7 by the way.
I am not seeing where I can do this. I can do the last XX days but I don't see where I can say I want the report to run for Monday thru Friday between 7AM and 5PM. Would you be able to give me some more direction?
You are looking at the time frame tab. You should be looking at the filter tab. You will find sample reports as attachments to this thread
Executing a Set of SQL Codes at a Particular Time; is it with Orion Report Scheduler or Something else?
I really appreciate you taking the time to respond.
Right now I have the following report and it gives me the past 5 days, which I run on Saturday so it gives me Monday-Friday results.
======================================================================
SELECT TOP 10000 Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
AVG(CPULoad.AvgLoad) AS AVERAGE_of_AvgCPULoad,
AVG(CPULoad.AvgPercentMemoryUsed) AS AVERAGE_of_AvgPercentMemoryUsed,
AVG(CPULoad.AvgMemoryUsed) AS AVERAGE_of_AvgMemoryUsed,
AVG(CPULoad.TotalMemory) AS AVERAGE_of_TotalMemory
FROM
Nodes INNER JOIN CPULoad ON (Nodes.NodeID = CPULoad.NodeID)
WHERE
( DateTime BETWEEN 41913 AND 41918 )
GROUP BY Nodes.NodeID, Nodes.Caption
ORDER BY 2 ASC
==================================================================
I just don't know SQL to make the report also give me the data only between 7AM and 6PM.
If you can shed some light that would be really great.
Thanks again
