I know that I can create a report on the receive and/or transmit utilization for last x number of days. Is there a way to create a report that find interfaces that the utilization is say 50% or greater more than an hour?
With an alert, yes. Not the most ideal/ most direct way, but can get the job done.
I thought of that but then I am unable to use the historical utilization data
Do you have Cisco devices that support RMON?
https://www.cisco.com/c/en/us/support/docs/network-management/remote-monitoring-rmon/13488-alarm-event.html?referring_site=RE&pos=2&page=https://www.cisco.com/c/en/us/support/docs/network-management/remote-monitoring-rmon/17428-18.html
I'm a Report Writer fan
This gives you a general idea of what you're looking for.