Shared Files for the Orion Platform
  • Insert html code into SQL query to show custom node availability

    Insert html code into SQL query Activate only when node down alert is triggered: Down EventType 5000 Up EventType 5001 HTML has a CASE clause in order to take control of percent availability. This script has a filter to show only events in a time frame 7 am to 4 pm
    • 5 downloads
  • SAM Application Widget to simplify Application editing and searching from a single Dashboard Widget

    This simple custom query widget simplifies the identification of which Applications are assigned to a Node and allow easy editing of the Application Monitor, Application Template or Node. As with all code posted on the internet, please test the code in a test environment to ensure it works as expected and meets your requirements before deploying in productions. To add the widget follow the steps below. Add the Custom Query Widget to any Summary Dashboard and paste in the attached text into...
    • 8 downloads
  • Custom Properties detected in Account Limitations

    This custom query widget will display any accounts which have limitation reliant upon Custom Properties. Please note this query does not directly identify the Custom Property Type, Name, or Value.  You'll have to investigate the details yourself.
    • 12 downloads
  • Custom Properties detected in Report Definitions

    This custom query widget will display any reports which have logic reliant upon Custom Properties. Please note this query does not directly identify the Custom Property Type, Name, or Value.  You'll have to investigate the details yourself.
    • 12 downloads
  • Custom Properties detected in Dynamic Group Definitions

    This custom query widget detects any Dynamic Queries for each group that rely upon Custom Properties. Please note this query does not directly identify the Custom Property Type, Name, or Value.  You'll have to investigate the details yourself.
    • 13 downloads
  • Custom Properties detected in Actions (Reporting or Alerting)

    This custom query widget will display any actions (Reporting or Alerting) which rely upon custom properties. Please note this query does not directly identify the Custom Property Type, Name, or Value.  You'll have to investigate the details yourself.
    • 15 downloads
  • Custom Properties detected in Alert Logic

    This custom query widget will display any alerts which have logic reliant upon Custom Properties. Please note this query does not directly identify the Custom Property Type, Name, or Value.  You'll have to investigate the details yourself.
    • 16 downloads
  • Alert Email Settings

    This script will create a report with the To/From email addresses and the SMTP server used for every alert. Orion.Actions.Properties.PropertyValue contains the SMTP server ID but is blank in the cases where the alert uses the 'default' SMTP server. This results in a server lookup value of NULL. Someone with more SQL skills can probably figure out how to deal with that appropriately. In this version it is handled with a CASE statement that populates the value 'DEFAULT' rather than having it show...
    • 9 downloads
  • Active alerts with acknowledge notes

    This is a method for handling events and alerts. The idea is that every time an alert is triggered, it can be acknowledged with the acknowledgment button. This way, the note can be saved in the historical tables. With this information, we can create modern dashboards and even integrate with Power BI for more detailed analysis. Modern Dashboard: Power Bi: The event is triggered, acknowledged by a NOC or SOC operator, at which point the acknowledgment note is added. Following this,...
    • 28 downloads
  • SolarWinds/Orion Map Inventory

    Custom Query resource widget to display an inventory of SolarWinds/Orion Maps: The following columns are displayed: Map Creator Map Name Entity Count Created Date (Local Time) Last Updated (Local Time) The complementary search query has also been provided. It allows you to search by either the Map Creator's account name or the Map's Name. If you'd like to enable search: Copy the same query to the Search Query field Remove the double-dash from the beginning of the WHERE...
    • 9 downloads
  • List of Maps

    Very simple list of maps that can be placed on a Classic Dashboard. It can also be modified for use in a tabular resource on Modern Dashboards. If you'd like to enable search: Copy same query to the Search Query field Remove the double-dash from the beginning of the WHERE clause
    • 7 downloads
  • Alerts Event Type Actions Report

    Hello THWACK Community, The SWQL Custom Query Alerts Event Type Actions Report, has been primarily written to show a list of ‘Failed’ Alert Events Type Actions, at the top with all of the other Alerts Event Type Actions listed below in a custom order. The SWQL Custom Query Alerts Event Type Actions Report, is to used to ideally identify and help troubleshoot the HEALTH: Failing Alerts Actions, that are shown in summary within the Orion Insight Report of the SolarWinds Platform. As follow up...
    • 25 downloads
  • NTA: Number of flows per Device/per Interface

    Below widgets are counting number of flows per device and per interface. By default, flows are counted per hour (last 4 hours). Each hour is defined by down sampling to '01:00:00' and it can be easily modified within the query, i.e. '00:15:00' if 15 minutes intervals are required. Additionally, below where statement provides full hours. Downsample(TOLOCAL(Timestamp),'01:00:00') >= AddDate('hour', -4, GETDATE()) If a current time is 18:33, then flows are counted as follows (4 full hours...
    • 10 downloads
  • Widget: VMAN ESX Host Alarms From vCenter

    This query was built to show active alarms in vCenter. Our specific need was to know when one of the NIC's on the virtual host went down. The alarm shows in vCenter and the status of the ESX Host changes in SolarWinds, but it was not clear why the host status changed in SolarWinds. This widget is added to the 'ESX Host Details' page and will filter active alarms by the host/node you're viewing.
    • 27 downloads
  • Multi-Statistic Data (Script Components) and pivot example

    I don't have to do it often, but when I do I can never remember how to "PIVOT" data between elements in the SolarWinds API. I decided to write something up and share it as a custom query. This particular example uses statistic and message data returned from SAM Script Templates. It doesn't matter if the sources are SAM templates or Universal Device Poller results - this same PIVOT logic should work. Please note that this isn't a simple copy/paste. You'll need to look at the connected data points...
    • 46 downloads
  • ICMP Status Only vs. Paid Nodes for HCO Details | Older than v2022.3

    Hello and salutations, Thank you for your consideration of our Hybrid Cloud Observability (HCO) product which is built on the SolarWinds Platform (formerly known as Orion). This new license model provides at lot of advantages over the heritage point products, and we group the various functionality of the various point products into a new product offering. Therefore, this document is to help determine the license tier you will be in by converting over your existing products into the new HCO offering...
    • 39 downloads
  • Daily Platform Maintenance

    I don't remember where I got this, but this is a custom query widget reporting the start time, end time, and duration of the daily maintenance on your SolarWinds Platform. As configured it pulls events for the last 7 days, but can be configured for longer times by adjusting the - 7 in line 44 to whatever duration you'd like. Be sure to change the Number of Rows per page setting in the Custom Query widget if you don't want pagination.
    • 76 downloads
  • Group Membership (Node)

    This is something I threw together to enumerate the groups (both traditional and maps) where a Node is used. It's designed to be placed on a Node Details page and will not function correctly on other pages (like summary pages, interface details pages, volume details pages, application detail pages etc.). Recommended query title and subtitle are also listed in the SWQL. It is search capable, and instructions are outlined in the query itself.
    • 33 downloads
  • Unmanaged Nodes with custom names

    This displays the name of the node, when the unmanage action begins, when it ends, the time the unmanage action was completed, and the name of the person in human readable form. You will need to acquire a list of Solarwinds users first. The code for that is at the bottom of the query Solarwinds doesn't have extra tables in the database to allow human readable names to accounts so unmanage actions are shown as Active Directory accounts. In our organization these read like this DomainName\user2868732...
    • 55 downloads
  • Widget: Node Status Root Cause

    I built a query to better show by a particular node is in warning/critical status. I know you can hover over areas to get that detail but I wanted to have it all in one place. Not all entries have a URI but the ones that do are hyperlinked in the query. Navigate to the Node Details page where you want to add this widget Click on the pencil icon on the top-left Click on 'Add Widget' button on the top-right Search for 'query' Drag the 'Custom Query' resource onto the page Click on the...
    • 109 downloads