-
Re: Need Interface IP Address details in Downtime Report
Hi We always suggest using SWQL instead of SQL where possible. But now that you almost have all the query I adjusted this on. Joined in the table "NodeIPAddresses" on both interfaceindex an…1 -
Re: Assistance Required for Bulk Maintenance Window Scheduling in SolarWinds
The easiest way is to use "manage nodes", and mark several nodes, click "maintenance mode" and choose a schedule for all of them at once. If you want to automate things, there is …1 -
Re: Trigger Action - Email SWQL/SQL in body
Hi, as @"maciej.sandecki" said, you are stating that it's a SQL query when it's actually a SWQL query. Here is a simple one: ${N=SWQL;M=SELECT N.caption from Orion.Nodes as N WHER…1 -
Re: Unable to access statistics and messages from alerts
Here is the same query but I have change it on two places to get the NumericData instead of StringData SELECT --DE.StringData AS [Message] DE.NumericData FROM Orion.APM.DynamicEvidenceCurrent AS DE -…2 -
Re: Unable to access statistics and messages from alerts
Ahh, thanks @"tobyw_loop1" , I forgot about that one. Haven't used it much over the years.2
