The most recent content from our members.
Good Day! I am trying to create a modern SolarWinds dashboard, I have a widget that shows current alerts based on my custom group and its working but the links are not working I imported a KPI widget from an older dashboard (someone else created a long time ago) and the links are working Can someone tell me the difference…
Dear Community Members, I am trying to build the interactive KPI widget by using below query. As you can see I have map the necessary dashboard ('Interactive KPI Table - Testing' ) in the query but still I am not able to achieve the result (interactive KPI widget). Furthermore, I have verified , the linked dashboard is…
Good afternoon Thwack Community, I am having trouble with a KPI widget that I am trying to repurpose in another KPI widget. The KPI will show the desired value but for some reason I can't get it to link to the Table Widget like the original KPI does. This is the query I am trying to work with SELECT N.TheCount , CASE WHEN…
Hello fellow people Can someone help me on a query please I am trying to build for our modern dashboard The query I am running is as below but I want the 2nd column returned to be what is displayed in the KPI widget SELECT TOP 10 n.FullName, round((n.Inbps / 1000000),2) as InMbps FROM Orion.NPM.Interfaces n WHERE…
Hello, I posted this question a bit ago and didn't get a response, so I am trying again for some help. I have a handful of availability reporting widgets on a modern dashboard that report based on type of site or report overall average availability for all sites for the current and past month. When I originally implemented…
Hi, looking for assistance please with a SWQL to show availability of a specific node or application availability as a KPI widget. Thanks
I'm fairly new to SWQL and SQL. Im having a hard time to make this swql query work. SELECT COUNT(1) as Count_Items, a.Status FROM Orion.APM.Application a JOIN Orion.Nodes n ON n.NodeID = a.NodeID WHERE Status = 14 AND n.CustomProperties.Device_Prio LIKE 'Prio1%' GROUP BY a.Status This counts the critical applications with…
Hello all, I'm new to Modern Dashboards and I'm trying to create a KPI widget that shows a down/critical application count but I need to filter by a custom property. I'm using a simple count but I'm not sure how to add the filter. Below is my count query: SELECT COUNT(1) AS KPI_Numbe from Orion.APM.Application WHERE…
Hello, I have the following KPI widgets that pull average availability for the month for each type of site we have. There are 4 different types of sites total, then one KPI widget that is the overall availability average of all sites. My problem is that the overall average does not calculate an accurate average based on…
Hello, I have the following SWQL Query that I have modified from a previous post so that it creates a KPI output. However, the output reads as a rounded integer. I would prefer if the output would read "99.35%" for example. Can someone assist in modifying my query to make that output read that way? Thanks in advance!…
It looks like you're new here. Sign in or register to get started.