Hi, I have been told to create a report that shows availability of our storage arrays for the last 7 days. The person who created the previous report did it by creating a dynamic query builder that ended up bringing duplicates and this is the strange part. By looking at the query that runs behind the report I can see this:…
Hey all, I'm trying to create a report of applications that are running on my nodes, but it's going to staff that aren't familiar with SolarWinds and template names. So I thought to include the Application Template Description field in my SWQL, but I can't seem to find the data in SWQL studio anywhere. For reference, here…
I have a simple PS script that is running a single query against our dev env, when I run it manually, works great so I know it's all setup within the script perfectly. When I have the Alert Trigger Aciton run the script, it will not successfully run the "Connect-SWIS" command. It returns a null in the $swis variable every…
Looking in to exporting then importing scripts to allow updating of our different SolarWinds environments for consistency. Exporting went well, contents look good. Following @KMSigma.SWI's guide During testing, have found that importing leads to importing except the email trigger/reset actions are missing although other…
Does a dark mode/theme exist for SWQL Studio?
Hi guys, As security is a priority for SolarWinds, what about providing a stronger authentication to use REST API rather than Basic Auth (user:password in base64) ? In my company, SolarWinds API is behind an API management platform with OAuth2 authentication (to avoid direct connections from users), but between this APIM…
I am trying to create a modern dashboard table widget with the following query from SWQL Studio. SELECT TOP 1 [Node].Caption , [Node].DetailsUrl , [Node].CustomPollerAssignmentOnNode.ID , [Node].CustomPollerAssignmentOnNode.CustomPollerName , [Node].CustomPollerAssignmentOnNode.CurrentValue ,…
Hi guys, I am currently stuck creating joins using the link icons in SWQL studio. See below example: I know that some how i need to use 'As' and create and alias in that query and reference it. In the above query i have info from orion.nodes in the query but i want to add info from orion.alertobjects table and…
I am tiring to search for the RawStatus of a Node based on Datetime. This is what I have so far but I cannot figure out how to modify this to search for the date and time. SELECT [Node].NodeID , [Node].CustomPollerStatistics.DateTime , [Node].CustomPollerStatistics.RawStatus FROM Orion.NPM.CustomPollerAssignment AS [Node]…
We have a need where an engineer (who doesn't have switch access) will connect a device to an interface and want us to find their MAC, which has been plugged into the network for maybe a minute. Wondering if we could fire the "pollNow" verb, if it also updates UDT with the Mac address table and IP Arp table. Otherwise it…
It looks like you're new here. Sign in or register to get started.