Page 1 of 1

CPU Usage Avg over time

Posted: Tue Mar 23, 2021 8:05 am
by meganwilliford
I am looking to be able to run a report for a host group metric that shows the average usage over a certain time period. I am able to do this using the Metrics report > Graphs and the average displays at the bottom of each graph per host (pic example attached for reference) but is there a way this can be listed in a summary table rather than having to go through each chart to get the average?

Re: CPU Usage Avg over time

Posted: Tue Mar 23, 2021 6:10 pm
by ssax
The only other method would be to view them in Home > Performance Graphs but that doesn't allow you to do it by hostgroup.

Home > Metrics is the closest you'll get given the existing feature-set. I can submit a request to development to request they add that as a feature on your behalf if you'd like?

Re: CPU Usage Avg over time

Posted: Wed Mar 24, 2021 11:32 am
by meganwilliford
Yes, please submit as a feature request!

Do you know if there is a database query that could potentially pull the average over 30 days?

Re: CPU Usage Avg over time

Posted: Wed Mar 24, 2021 6:30 pm
by ssax
A DB query wouldn't do it because the data/averages are stored in the RRD files under /usr/local/nagios/share/perfdata not in the DB.

You could script it out through the API, see here on your server:

Code: Select all

http://YOURXISERVER/nagiosxi/help/api-object-reference.php#objects-rrdexport
Since it only supports a single host/service that's the reason it would need to be scripted out.

I have created the request:

Code: Select all

FR: XI - Home > Metrics - Add the ability to show min/max/average (selectable) in table summary format
Please keep in mind that the decision to implement the enhancement is at the discretion of our development team.