Custom Queries

Show the top 10 nodes with the highest response times.

Identify nodes that have not been polled in the last configurable time (say 1 hour). Useful to find monitoring gaps.

List IPAM Subnets that have less than 10% free addresses remaining. Helps to plan for capacity or expand subnets.

Show top 10 application monitors (SAM / APM) which have the highest number of failures in the last 24 hours. Useful for identifying problematic apps.

List all network interfaces experiencing packet loss above 5% in the last hour. Helps in detecting network quality issues.

Find all nodes where CPU utilization > 80% and Memory utilization > 75% in the past 30 minutes. Helpful to quickly spot overloaded servers.

IPAM Audit Events are stored in a separate table from other SolarWinds audit logs, therefor they don't show up there. But all changes to subnets and addresses are stored. As of now there are no out-of-the-box widget for this, but here is the code to build it. I add a "Custom query widget" to IPAM Summary dashboard. Then add attached code for both "custom SWQL Query" and "Search SWQL Query". Adjust to your liking: With the search box you can search for date, username or message.

Want to see the log messages from a node, on the Node Details page ? SWQL and Custom Query will get you all the info you need! On the Node Details page, add a Custom Query Widget and paste the attached code. The code has two parts, one for showing the last 10 messages and one for showing how many logs has been received last 6 hours. For the message part I have shortened it to the first 50 characters, to save space. Change it if you want to. Use the part you want. Adjust to your liking.

This SWQL Script return all enabled alerts when your trigger action is sent an email, show EmailTO, EmailCC, EmailBCC If you have escalations actions you can see this as well:

Hello, This is a follow-up to my other scripts for pulling custom poller assignment values. I wanted to create a widget to pull all custom pollers with a name matching mine (in this case, AVTechConvert). It dumps all these values into a temporary table and returns any that are more than 30 minutes old in UTC. I wanted this because these are temperature values for server rooms, etc. and we definitely do not want these to be out of date and go unnoticed. It actually saved me just a few days ago...

Custom Table widget for calculating & usage of IPAM IPv6 Supernets. As you may know, IPAM approach in calculating supernet usage is a bit misleading, which I described here: IPAM - Better Supernet Utilization In Custom Table Edit you will need to define Percentage Bar:

Custom Table widget for calculating & usage of IPAM IPv4 Supernets. As you may know, IPAM approach in calculating supernet usage is a bit misleading, which I described here: https://thwack.solarwinds.com/products/ip-address-manager-ipam/i/feature-requests/ipam---better-supernet-utilization In Custom Table Edit you will need to define Percentage Bar:

I was playing with NTA alerts, and realized that they were far too granular. So I came up with this: SELECT TOP 10 Caption , Nodes.FlowsByHostname.DestinationHostname , Nodes.FlowsByHostname.TimeStamp FROM Orion.Nodes as Nodes WHERE Nodes.FlowsByHostname.DestinationHostname LIKE '%HOSTNAME%' AND Nodes.FlowsByHostname.TimeStamp >= AddMinute(-17,DateTrunc('minute', GetUtcDate())) AND Nodes.FlowsByHostname.TimeStamp <= AddMinute(-2,DateTrunc('minute', GetUtcDate())) Just modify the DestinationHostName...

The purpose of this widget is to identify which polling engine discoveries are running from as well as identify which discoveries found new nodes vs changed nodes. This is highly dependent on naming your discoveries accordingly, and I didn't see a way to add a link to directly go to editing discoveries here, but it should at least help people get an at a glance for "what happened?" SELECT TOP 20 e.Servername as "PollingEngine" , Frequency , LastRun , Status , NotImportedNodescount as NewNodes ...

In the process of some of what I do, I realized I didn't see any sort of report (or widget) that specifically tries to identify switch stack problems. This widget should generally highlight power or data ring issues in general. Hopefully this helps some folks out. Query: SELECT TOP 1000 Displayname , DataRingRedundant as DataRing_Active , StatusDescription , ONS.Nodes.IP_Address , DataRingStatusDescription as DataRing_Status , PowerRingStatusDescription as PowerRing_Status , RingFailure ...

Intro Recently stumbled upon a modern dashboard widget type called drilldown. I had seen this before but didn’t give it much thought to how it would be used. That is, until I wanted to try and recreate the All Nodes widget from the Home Summary page in a modern widget. I thought about using a table widget but scrolling and the “row/column” feel didn’t feel as clean as a dropdown. As I began playing with the widget, I was unable to find any documentation related to this drilldown widget, which has...

Greetings, I built this with my temperature page that I made up a year or 2 ago in mind. One of our Networks guys wanted to poll the system expiration date on his Cisco ISE appliances via API and have it displayed in a similar fashion (Green Yellow Red) The challenge was that this value is stored in a String format that makes date time calculations difficult. This script pulls that value, converts it to a datetime format, and then when used as the data source for a custom table with HTML...

looking to see if there is an option to hide or turn off legend in custom query chart. It takes up to much dashboard real-estate, and as long as the hover action maintains, the legend is not needed.

Here is a query to get the component count per App Monitor per Server SELECT [C].Application.Node.Caption as Node , [C].Application.Name As Application , [C].Application.Template.Name As Template , Count(*) as Components From Orion.APM.Component [C] Group by [C].Application.Name, [C].Application.Template.Name, [C].Application.Node.Caption Order by Components Desc

Hello, I have prepared a full video tutorial for adding custom Syslog and Trap widgets for Node & Interface Details Views. You can also use below description and attached TXT file will all the queries. First Node Details widget will allow you to jump directly from Node Details view to Log Viewer Dashboard and start the log analysis: In order to create above widget, please add "User Links" widget and include below hyperlinks: Log Viewer (Syslog & Traps) - Last Hour /ui/orionlog...