First off thank you to wluther and his posts that led me in the right direction to create this, as well as mesverrum for his query on node outages.
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)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.