I used to have an old report writer SQL report that showed me every alert that has been active for at least 48 hours on v10.7. This worked until we migrated to 11.5.2 and they changed the Alerts table. I can't find a good way to do this since 11.5.2.
Has anyone been able to do something like this?
TIA!
