The most recent content from our members.
Trying to get average Availability for a KPI widget for the last 7 days and using below Query SELECT AVG(E0.[AvgResponseTime]) AS Counter FROM Orion.Nodes AS E0 WHERE ( ( E0.[CustomProperties].[x_x_x] = 'abc' )) AND Date.Time BETWEEN GETDATE() - 7 AND GETDATE() But I am getting below error when validating the query:…
It would be great if KPI widget had an option to add links with extra data field, like other widgets have. For example, if we click on Alerts KPI widget that might take us to alerts page. i have tried to include as link in SWQL query , but it does not support. we are using the Latest version of Solarwinds.
SELECT COUNT(1) AS KPI_Numbe from Orion.Groups WHERE Status= 2 Hi All, Some ideas needed , the above SQL has been used to created a KPI widget to list DOWN nodes within the full Orion.Groups set. I need too be able to change the SQL to not list KPI data for all GROUPS but for specific only GROUPS . For example based on…
suppose if there are 100 nodes in the environment and 23 nodes are down then the query should give the output as 23%, i will be building on the base query but the base query is giving me some errors i have made a draft SWQL query but the output is giving me some errors about aliases missing Base Query <span>select (select…
I have a PerfStack widget which is showing realtime GlobalProtect active sessions from my Palo Alto and I would like to turn this into a KPI widget on a modern dashboard. I have very limited SWQL experience beyond making some basic up/down KPI widgets and would like some advice on where or how I might pull the data for…
Hi Can any one generate SWQL query to get % Availability of 7 Days , Last month. Mention query is of Today's Availability. SELECT Availability , Status , Color FROM ( SELECT ROUND(AVG(rt.Availability), 2) AS Availability , 'UP - ' + SubString(tostring(DATETRUNC('day', GETDATE())), 0, 12) AS Status , '#30b230' AS Color FROM…
Part 1 Recap Early in this short series, we talked about SWQL and how to format queries to bring information out of the SolarWinds Orion Platform and making it work for you and your users/customers. If you’re just joining us, I’d recommend reading up on that post before moving forward since I’m building directly on those…
It looks like you're new here. Sign in or register to get started.