We're looking to write a report that calculates how long an interface was at x% (in our case, >90%) for a given time period. I'm by no means even a SQL novice and haven't run into any examples or canned reports that are doing this. All of my knowledge and reports are sampled from the community or prepackaged in the product.
Has anyone out there written a report that does this or something similar? Basically, "the interface ran at >90% for 200 minutes today."