I'm trying to create a custom resource window within NPM (I have version 10.5) that displays the number of Up/Down nodes, based on specific Custom Property fields
I.E.
Active Nodes: <number of up nodes in X city>
Offline Nodes: <number of down nodes in X city>
I'm going to be creating brief summary pages for each of our country/districts where we have active networks, and I want to just have a small window at the top of the page that just gives the number of up/down networks in that region.
I'm not very familiar with SQL, so anything that's above and beyond the basics that SolarWinds already provides is beyond my expertise level.
So I thought it might be a good idea to see if anyone with more SQL experience had any suggestions.
Thanks in advance!