Here is a screenshot of the results:
This resource starts with just the calendar that shows a count of Branch Outages and color codes them depending on the amount of outages that day.
Once you click on a day a Timeline will appear that breaks down all outages that started on that day.
The code provided can easily be changed to your needs if you are familiar in SWQL. There are 2 main SWQL queries that are running here and I have formatted them to be read easily as in the HTML resource. It is condensed to one line, and I have added comments to help explain each line (needs to be removed when condensing to one line for HTML).
SWQL Query for Count of Branch Outages per day: (line 5)
SELECT SUBSTRING(TOSTRING(DATETRUNC('Day',ToLocal(E.EventTime))),0,12) AS Day, --Format Ex. Apr 19 2019 Count(*) as [Qty] --Count of Branch Outages FROM Orion.Events E --Table we are querying WHERE Year(TOLOCAL(E.EventTime)) = Year(GETDATE()) --Only get events from the current year AND E.EventType = 1 --Get Node Down Events AND E.NetObjectType = 'N' --Only Nodes AND E.Nodes.CustomProperties._DeviceType = 'Branch Router' --Custom Properties assigned to Branch Routers AND E.Nodes.Status <> 9 --Don't grab devices currently unmanaged GROUP BY DATETRUNC('Day',ToLocal(E.EventTime)) ORDER BY DATETRUNC('Day',ToLocal(E.EventTime)) DESC --Order by newest to oldest
SWQL Query for Timeline Events: (line 56)
Other Posts that helped with making this:
If there are any questions or improvements I could make please let me know!