Reports Database

[Jesse Worley]

Hey all, I apologize if this has been covered before.

I'm currently running weekly reports and having those reports sent out in various formats to people who need them, but lately I've been asked for monthly, quarterly, and yearly statistics.

From what I understand of HostMon, I have to reset the statistics on each reporting cycle to get accurate uptimes and ratios. However, if I was to set up a database and import the weekly (or perhaps even daily) information into that database, could I not use it to generate custom reports for specific tests within specific date ranges? Assuming this is possible, has anyone actually taken on this task?

I'm lucky enough to have a few good SQL and Crystal Reports guys in the department, but before I go outlining this as a project I wanted to find out if any of you have done this kind of thing.

Thanks for any assistance you can offer.

Jesse

[KS-Soft]