I have been using this report for some time to identify what the potential impacts of making changes to a custom property are.
It looks through all the properties, then checks them against the following common use cases:
Alert trigger/reset conditions
Report which shows a summary and details for alerts over the last 7 days.
Details are grouped by the Severity, and then the alert name. It does not care one way or another if the alert is still active.
Inspired by Alerts Weekly Report post in Alert Lab .
This report is based on https://support.solarwinds.com/SuccessCenter/s/article/Create-an-SLA-report-showing-average-SLA-availability-during-business-hours?language=en_US
However, instead of using individual node availability this uses the availability of a group (not the member availability percentage), averaged per day to provide the SLA.
NOTE: This report is meant to be an EXAMPLE, not a ready-for-production asset. First, it mimics the "All Alerts" resource by including an "AcknowledgeIt" link which will let you acknowledge any item on the list. Second, it includes a custom property - "Importance" to show that you can include custom fields and use them for sorting Third (and finally), it includes a clickable node-name simply to show that this can be done as a technique There is a detailed how-to-series on the techniques used to...
This report returns all nodes that were down during a specified time frame, such as October 1st - 12th 2018, along with duration each node was down. The report shows only nodes that were down for longer than 15min by default, but this value can be easily changed, along with the start and end times for the reporting period.
An example report, to demonstrate retrieving SNMP trap values, from the Trap and TrapVarBinds database tables. The SQL has two filters, one on IP and one on trap type, which are pretty well wildcarded (SQL uses % as its wildcard character) for this example, please adjust as required. Once these have been modified the report will show the last 250 traps, or to be more precise the 250 rows of the table, and within each TrapType you will find multiple lines for each trap, each one being a line of the...
SolarWinds Orion includes self-management features to perform database cleaning, re-indexing, and data summarisation. This function is scheduled by default to run at 2:15 each night and will take an amount of time relevant for the volume of data your platform is generating. If it starts taking longer than normal (your normal could be 24 minutes or 2 hours 24 minutes. Baselining is important; you need to know this. We were recently asked by a customer if it was possible to generate a report to look...
An example of using SQL to create a node down report, with durations. There will be a version 2, that gets the node down event timestamp for ICMP nodes (which currently show as 0). Also has the detailsURL in there, to provide hyperlinks from the node captions.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.