Using Custom Properties would be a good step to start from. then you can use that report posted by jtimes Outage Duration Last Month as an example and modify it to match Interfaces events and filter on the custom properties.
You will definitely need to use an Advanced SQL Report.
You can get the Events Type definitions, ID from the EventTypes table in the database.
Let us know how you progress.
Hi, thanks for the response
I'm Just starting to go through all my routers and label them Primary or Secondary.
Let me know if I am thinking about this wrong.
Because we have some sites with 1 router with 2 circuits, and other sites with 2 routers each with one circuit I am thinking to do 2 separate reports, one for 1 router sites and one for 2 router sites.
On the 2 router sites I can label the router itself as Primary or Backup -- for these would run the report from the nodes table.
On the 1 router site I will label the Interfaces Primary or Secondary -- then run report via the interface.
The reports seem like they will be complicated but will get me what I need.