Nagios Support Forum

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?

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?

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?

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:
Since it only supports a single host/service that's the reason it would need to be scripted out.

I have created the request:
Please keep in mind that the decision to implement the enhancement is at the discretion of our development team.