-
Reporting on Historical Data for Trend Analysis
Hi, I have this SWQL query but I want it to show historical data. There are options to choose "peaks BPS" from a time period but I cannot see the option to show "peak percent utilisation" from a given time period. This is a pretty simple and essential requirement for trend analysis. Please can you advise on how to achieve…
-
Reliability Report
I want to generate a Reliability report that captures metrics like Node Caption, IP, Status, Uptime Duration (in minutes), Start and End Downtime, Downtime Duration, Outage Count, MTBF (Mean Time Before Failure), and Availability. This report should have the flexibility to be produced on a daily, weekly, or monthly basis…
-
Stopping Duplication Of VM Names and merging them.
I have a SWQL script below that looks at containers and VMs and then groups them.The script is below SELECT n.DisplayName AS [Node Name] ,CASE WHEN m.containerID = '218' Then 'DBA' WHEN m.containerID = '217' Then 'BICC' WHEN m.containerID = '219' Then 'Finance' WHEN m.containerID = '220' Then 'Finance Payroll' WHEN…
-
Report to show all nodes that are muted via maintenance mode
Hello, Please can someone show me how to create a custom report to show all nodes that are muted via maintenance mode? I'm a report beginner I tried this How to view all nodes that are muted via Maintenance Mode - Alert Lab - The SolarWinds Platform - THWACK but got the "Query is not valid" error. Many Thanks!
-
Report containing Alert Name and Node associated to that Alert
Hello All, Please could someone help me in creating a (SQL, SWQL, Custom, OOB...) Report containing All Enabled Alerts along with Node/object Name associated to that alert. In simple words there is OOB report showing "All alerts this objects can trigger" but this can give a report on a Specific object, whilst I need…
-
Where is the File Existence Monitor component file path values located?
Where in the database would I find the details for file paths being monitored by a File Existence Monitor component? I am in the process of building detailed reports for our nodes, applications, and components we have configured.
-
I need to calculate the 90th utilization for memory usage in a swql for a report above a threshold.
Example" Server max Memory Usage => 90% or 80% for 20 minutes on 1/1/2022. I am clueless on how to incorporate the time the max memory usage exceeding the threshold. Example? Select caption, location, max memory utilization where max memory utilization => 90%? Can you help me?
-
Adjusting a SWQL Application query to grab from Nodes not applications
Hi Guys, I found this monthly application status template to create a weekly one for a availability monitoring i got as a task: SELECT ADDWEEK(WEEKDIFF(0, GETDATE()) - 1, 0) AS Month, Nodes.Caption, Nodes.DetailsUrl AS NodesDetailsUrl, Application.Name AS ApplicationName, Application.DetailsUrl AS ApplicationDetailsUrl,…
-
Node Group Availability Report for Last Week & This Week in SWQL Query
I wrote hard-edit SWQL for this month SELECT [data].[DisplayName] AS [Site] , [data].[ContainerStatus].[PercentAvailability] AS [PercentAvailability] , [data].[ContainerStatus].DateTime as [AvailabilityDate] , AVG([data].[ContainerStatus].[PercentAvailability]) AS [AveragePercentAvailability] , DateTrunc('Day',…
-
Report to show all alert generated events within a certain date and time range.
Hello all, I am looking to create a report that will show all alert generated events regardless of state; whether it is active, acknowledge, reset, etc within a certain date and time range. I want to be able to do this so I can tell if alerts are not being triggered to the appropriate parties and a few other reasons. I am…