I'm attempting to set up long-term device up/down monitoring based on the events generated in Orion - so we can ferret out which circuits have up/down issues. I can generate a report based upon the events in the database, but management is wanting the ability to go back three months. Would keeping three months of events cause the database to grow to an unmanageable size? Or is there a better way to get the data I'm after. Basically, I'm looking to track devices that had greater than X "Device Down" events for the specified time period.
Relatively speaking, events don't take that much database space.