The most recent content from our members.
Greetings to the community, I would be needing the query that generates the Group Volability report (With Members) - This months to generate a widget, where can I get it? Or if someone knows it, I can share it. Thank you
Currently when creating a custom widget on a modern dashboard the only option in the data model section is for a custom SWQL query. I would like to add the option to select either custom SWQL or custom SQL. This will allow more flexibility on the modern dashboards. If it is not possible to add it to the existing widgets,…
I have created a custom SWQL query report, but when I try to enable search using the "Search SWQL Query" option, the search field doesn't appear in the output. Could you let me know if I'm missing any steps? This is my first time using a search in a report. Custom SWQL query: SELECT n.Caption AS [Node Name], n.IPAddress,…
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…
We installed DPA 2024.4 which supports using a gMSA Account for monitoring. The monitoring is working perfectly, as are Alerts that do not use a sql query to determine the Alert condition/status. Any alert on any Instance that needs to execute a database query is failing with this error: "A connection to the monitored…
Can anyone help me with query to fetch CPU peak % (last 2 hours) for any specified database node either from DPA reporting database or are any APIs available to fetch this information.
Greetings, I need to get IP Addresses of Interfaces (which are in NodeIPAddress basically but couple more info from Nodes and NPM Interfaces also. Came up with this query but for every Interface, the IPAddress table is repeated. So instead of 19 rows, I get 437 rows. Can someone with knowledge help please. SELECT DISTINCT…
Hi , Please help with following SWQL query: SELECT E.EventCode AS [Event ID], ToLocal(E.TimeGeneratedUtc) AS [Event Time], E.ComputerName AS [SQL Server], E.SourceName AS [SQL Instance], E.User, E.Message FROM Orion.APM.WindowsEvent AS E INNER JOIN Orion.APM.Component AS C ON E.ComponentID=C.ComponentID INNER JOIN…
Hello Community Members, I am looking for the custom query/Table Details from the database manager to pull the data for All Alerts this object can trigger. the object can be a Node, Volume or a SAM Component. I want to pull data for multiple objects. SolarWinds does provide Out of the Box option to pull data for this type…
Hi Folks!! Background: I have zero knowledge of solarwinds. I am writing a powershell script where I want to get the data from availability report (Node, Hostname, Availbility %, etc.). I am looking for a query to get the same. My Solution: I found below query but it only gives the report information. query => SELECT…
It looks like you're new here. Sign in or register to get started.