The most recent content from our members.
Is there a way to make alert on Interface which is flapping Up and Down in certain time window? I have created SQL query which lists "interface down" messages from events table (i.e. 3 occurences from same interface in 30 minutes). I cannot use that query in alert engine as Custom SQL Query limits search on certain tables…
Good Day All. Just handed a new monitoring requirement, as follows: Linux server runs a regular process to drop a text file onto a certain folder ("drop folder"), similar to below: PROCESS1 VALUE1 OTHERVALUE1 PROCESS2 VALUE2 OTHERVALUE2 PROCESS3 VALUE3 OTHERVALUE3 ... The customer wants to ingest this file into Solarwinds,…
Hey folks, Hoping y'all can help me out a bit here - I'm a bit of a novice when it comes to databases, and I'm hitting some snags with a business request that's come in. We're looking to create a report that outputs sums of interfaces in a given VLAN, per node, grouped by their container. I can get somewhere with SWQL to…
Hello! Has anyone tried to create a report with the Issuer and Owner of SSL Certificate? We already have a report in format (e.g. Days remaining, SSL certificate (with URL and expiry date) but would it be possible to add another columns (e.g. Cert Name, Issuer, Start Date, Expiry Date, Days Remaining and Owner) I'm using…
Hi All, I was hoping to get some help - as I understand there is no way at the moment for solarwinds to Alert when a number of port channel member goes down natively. I was hoping there is a way it can be done through sql/swql? (not so great when it come to queries ) Any help would be greatly appreciated i.e Node…
Unable to create reports on blocking query & backup status in DPA. Tried with custom SQL query in SAM. But it gives query invalid. If I use the existing template for blocking query (custom chart), I am unable to get SPID, blocked query details in the report. If I use custom table, it gives only current value not the…
One can currently use the "graphical query builder" or "hand-edit a SWQL query" on widgets for the modern dashboards. It would be nice to also be able to use SQL to build the widgets.
Hi, Please suggest if there is a way in Solarwinds 2020.2.6 to view the SQL query executed for the reports created using Orion web console. We are using OOTB reports in solarwinds and wanted the SQL query tirggered by these reports to use with our native dashboard tools. Thank you.
Hi Guys, Hope someone will be able to shed some light on it in case you had something similar happened to you. I have a lot of counters based on "SQL User Experience Monitor" component type across all our infrastructure. Some of them, randomly, on random servers, random SQL queries, would give the following error: A…
I have been struggling to find a way to alert on Application status, but provide Component status in the alert e-mail. I know that there are several macros that give me some of this information (ComponentsWithProblems, etc), but that is not enough. I want the error message associated with each component. I found the field…
It looks like you're new here. Sign in or register to get started.