-
Integrate SWQL Studio (web version) into SolarWinds Platform Settings page.
I love using SWQL for modern dashboard, classic dashboard widgets, alerts & reports but i hate having to switch back and forth between SWQL Studio and SolarWinds. So this feature request is to bring SWQL Studio into SolarWinds Platform/ SWOSH. This is kind of do-able when building modern dashboards, so why not bring it in…
-
Importing/Exporting Modern Dashboards
I think I posted this somewhere else, but I wanted to put it here so that it's easily accessible to all those interested in the Orion API and SDK Discussions. Table of Contents * Preamble * Doing the work in SWQL Studio * Moving to PowerShell * The Simple Step-by-Step Process* Get PowerShell 7 * Get the latest SolarWinds…
-
Need help with a SWQL query
I wrote this query to get the MWs created on SolarWinds. I wanted to check if we could add a column which shows the date and time the MW was created in UTC SELECT TOP 1000 EntityUri, Caption, IPAddress, tostring(SuppressFrom) as [Suppression From], case when SuppressUntil is null or SuppressUntil = '9999-01-01 00:00:00'…
-
We are looking for to gather information using SWQL Query
Hi, As part of our regular reporting process, we are pulling a report from solarwinds for node CPU, MEMORY and DISK Utilization data. We are now working to automate this process using SWQL queries. However, when attempting to extract historical data via SWQL, the queries are returning no results(giving errors) We would…
-
SWQL Trimming/removing part of a string in a select statement
Hi all, I have a SWQL query to get my VMware datastore serial numbers, vcenter servers, cluster and the vendor, i ideally need to strip out everything in the vendor column after the first '(' but cant get it to work, im fairly new to SQL/SWQL, so any advise would be amazing, SWQL query is below: SELECT…
-
SWQL Studio not being developed?
SWQL Studio hasn't been upated since Jul 24, 2023. Almost two years ago. Just curious - Is this no longer being developed? Not sure if there is a feature request for SWQL studios but here are two issues which has been problematic. 1) The color scheme is really bad. I can't read the highlighted text. Maybe it's me, but for…
-
Unable to query NCM entities with SWQLStudio
Ok, this is a fun one. I can a basic query in the web console swisquery page - select top 100 corenodeid from ncm.nodes. Not a problem. I can create and run NCM based report in the web console and open the config manager etc. I have the Admin NCM role. It is all good, UNTIL I open SWQLStudio. Then I get nothing but the…
-
SWQL Query Unnamed Columns Problem
I don't think there is anything in this swql query that is not AS. I also tried it with and without square brackets. Still the same error. Can you please solve it? SELECT OrionNodes.Caption AS Caption, OrionNodes.DetailsUrl AS DetailsUrl, OrionNodes.Status AS [Status], OrionNodes.Vendor AS [Vendor], OrionVendors.Icon AS…
-
SWQL Historical Node Status Events where a custom property is true
I am trying to build a query and eventually a dashboard for our Remote locations only I cannot seem to get the Node statuses I tried to create an alert to key off of but i do not get the proper node statuses Historical Event Description for the last 30 days Nodes where an Interface has Custom Field: Wan_Interface =True…
-
Help Creating SWQL Query That Generates a Report of Missing Devices at a Site
Hello! First time poster. I have what feels like a complicated ask (hopefully it's not and i'm overthinking it) and would like to gain insight or assistance coming up with the best way to go about this. I work at a company with 1100+ sites. Each site should have multiple switches, firewalls, security panels, DVRs, etc. I…