The most recent content from our members.
This is @tphelps01 idea not mine, just posting it as it's a good one FEATURE REQUEST - Add SAML authentication for SWQL Studio - THWACK SWQL Studio does not allow for SAML authentication to connect to the Orion Server. Please add SAML authentication to SWQL Studio
SWQL Studio does not allow for SAML authentication to connect to the Orion Server. Please add SAML authentication to SWQL Studio
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…
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…
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'…
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…
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 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…
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…
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…
It looks like you're new here. Sign in or register to get started.