The most recent content from our members.
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!
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…
hi guys, pls help. I have these weekly reports I built in report builder, but now I need help with the SQL equivalent. I'm not so good at SQL queries. Pls see my screenshot for my reports table for my web report. I really appreacite any help, thank you. Availibility and Response Time for nodes Weekly Volume Usage Weekly…
We have a couple of thousand reports that are going out to whoever wanted them when they were created. I am looking for a way to start auditing the Reports that have been created for about a decade now. Does anyone know a way to get a report that shows the Report name as-well-as the Action, Schedule and Recipient(s) it is…
Hi, I found this query on Thwack but there is a problem I need to classify per group that group have a customer name with a user =========SQL========= SELECT DISTINCT ahv.Name 'Alert Name' ,ahv.RelatedNodeCaption 'Parent Device' ,ahv.EntityCaption 'Alert Object' ,ISNULL(lastOne.Qty,0) 'Last 1 Day' ,ISNULL(lastSeven.Qty,0)…
Anyone successfully got a SQL report to show on a Modern Dashboard? It it even possible since Modern Dashboard widgets only appear to use SWQL. Example of the code: SELECT TOP 10 RowID, CreateDate, SORTORDER, TYPE, COUNT FROM XXXXXX.XXXXX.XXXXX <- name of the DB in question on the same DB server I found this request.. (+)…
Hello I'm having some trouble creating a report. I have different vendors devices and I'm needing to do a weekly report that shows the a specific vendor, the interfaces on the devices, and the peak traffic on each interface. Im not well versed in sql, and the report wizard is not cutting it. I can do a peak report but it…
Hi Team, This highlighted subject report working fine in the old version of 2017.3.5, but now not working in the latest version of 2020.2.5 (we migrated recently) if we copied the same SQL command pasted over here. Report Name : 90/95/99th Percentile Traffic Rate - Last 7 Days ( working based on SQL query). Working -…
How can I create a swql/sql report that shows data in 15 mins interval? I can create this report on a chart but I need it to be replicated in a web report/report writer
I make a lot of custom SQL reports now that the Web Report Designer allows me to publish them with more style than before. However, I am not able to get the nice automatic Node Details links to appear for each returned Node. I looked at several .OrionReport files and these all appear to have some complex XML formatting to…
It looks like you're new here. Sign in or register to get started.