Is there a way or has anyone been able to use the database from Orion to create a live health report?
Which ever OID Orion pulls a certain percentage has to be met. 0-65% red, 66-90% yellow, 91-100% green
A webpage then has the site name and devices. Below each device the color of the device percentage online is displayed. You can click on the color marker and it tells you what is good and bad by host and ip?
From what it appears you are asking for, it may be beneficial to take a look at the Custom Tile widget. This resource provides a flexible tool for rolling up status of monitored entities and allows you to perform a drill down into the list by host and ip.
Available in the Widget Drawer, the Custom Tile offers a ton of flexibility to users who want to see the overall health of a set of objects without having to scroll through lists.
Choose from any entity type currently being monitored by Orion such as, Applications, Transactions, Nodes, or even NetPath Services. If you would like to filter even further beyond simple entity types, there are 2 options available to you.
The Advanced Entity Filter makes it easy to select conditions via a query builder like Custom Properties to quickly specify a certain set of entities.
The Advanced SWQL Filter is also available if you prefer to unleash your own scripts.
I built something like this for our C-Level staff so they could look at one graphic and see all one hundred of our facilities as green, yellow, or red. They can click on a circle to drill into a site that's yellow or red and see what's down.
But I feel the most practical solution for my team is just to have the front page of NPM up and running all the time, with the Down Nodes view at top and Center, followed by the Hardware Health Overview, and a few other simple and incredibly helpful widgets alongside them. That seems to show us everything you asked for.
Here's the high level WAN view I created for the C-Level folks:
It turned out later that Management didn't take / have time to be clicking on yellow or red sites, since C-Level staff couldn't take action on the information. They ended up not looking at it at all, so we stopped updating sites that have changed IP addresses or that have been merged or dropped.
The work was a waste of time from my point of view, but someone up high believed it would be useful. Right up until they were expected to regularly view it and take actions on it, which helped them discover the Network Team was already taking action on it before the C-Level staff had time to discover something wasn't right.
A good NPM front page does the job better for us, and C-Level trusts us to be on top of all issues. Just as it should be.
Use NPM to create a new Map. Drag the nodes you want displayed onto the map and put them into a pretty order. Rename the nodes so your high-level staff can understand which city or facility or department each one represents. Name the map appropriately for your audience. Give them Read-only rights to it. If necessary, create user accounts for them and assign appropriate rights for them to view the new map. Then send them the URL to view the map.
You could take the extra step of putting in a geographic map in the background and placing the nodes in their correct positions on it, for some intuitive use.
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.