The most recent content from our members.
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, Can anyone help me to tweak a report using SWQL/SQL query? I need to extract all the Top 25 Interface Utilization with 90/95/99th Percentile Traffic every 2 hours? SELECT Interfaces.InterfaceId ,Nodes.NodeID ,Nodes.Caption AS NodeName ,Nodes.DetailsUrl AS NDetailsUrl ,Nodes.VendorIcon AS Vendor ,Interfaces.Caption AS…
Good Afternoon everyone, Since a short period I've started working on an assignment given to me by my organization its Developers. I am not well known with Solarwinds, but learning. My IT manager asked me to create multiple Node Groups which are specifically for the IT production environment per country. He also asked me…
I have adapted one of the custom alert queries I found here and was able to edit it to my needs and get it work. However I am stuck on one piece and I hope to get some help. I have a Where Clause that will filter out alert that I do not want to see "where o.AlertConfigurations.Name not like 'alert I don't want to see'"…
This is based on the the SWQL 95th Percentile Traffic Rate – Last Month report and now using SQL. I would like to be able to group the data by month summarizing all historical data. SELECT n.Caption as NodeName, format(DateTime,'MM/yyyy') as Report_Date, Max(In_Averagebps) as maxInMaxbps, Max(Out_Averagebps) as…
Recently I have found it frustrating that there were no historical statistics for polling engine performance. Sure, you can see the current information for them in the Engines table, but no historical data for that information was available. Yesterday I found a solution to this and added it to my custom admin page.…
Hi, I am trying to create a monitor for all the SQL server DBs we have to alert if different SQL DB options are ON/OFF. Like if the auto create statistics option is OFF, it should raise an alert. I can easily setup a monitor using simple SQL as: SELECT COUNT(*) FROM sys.databases WHERE is_auto_create_stats_on = 0; Then…
Hello Everyone, I couldn't find built in report that can help me to filter the triggered alerts in certain time duration, like between 10:00 am to 4:00 pm on Tuesday - Thursday. I have attempted to build sql query with my desired columns and wanted to use BETWEEN function. however the time and the date are stored in the…
Hello All.. I have looked around and cannot find what I am looking for, so am resorting to asking the community experts.. I have a sql query that returns six columns and 24 Rows.. The column names are ReportHour, PrevDayApproved, PrevDayDecline, Approved, DeclinedEach, reportHour1... Each Row has a value associated with…
I'm in the process of a drastic overhaul of our Orion Alerts, simplifying them wherever possible. To be thorough and secure that there is no disruption or miscreation of alerts, while making changes and/or removing custom properties within alerts, I am running a query in the db on the Alert Definitions, keywords or fields…
It looks like you're new here. Sign in or register to get started.