Shared Files for the Orion Platform
  • Translate date from API returned as Day Mon DD HH:MM:SS TZN YYYY (Cisco ISE) and display color coded

    Greetings, I built this with my temperature page that I made up a year or 2 ago in mind. One of our Networks guys wanted to poll the system expiration date on his Cisco ISE appliances via API and have it displayed in a similar fashion (Green Yellow Red) The challenge was that this value is stored in a String format that makes date time calculations difficult. This script pulls that value, converts it to a datetime format, and then when used as the data source for a custom table with HTML...
    • 1 download
  • Custom Chart Legend - Can it be hidden/removed

    looking to see if there is an option to hide or turn off legend in custom query chart. It takes up to much dashboard real-estate, and as long as the hover action maintains, the legend is not needed.
    • 1 download
  • Component Count by App per Node

    Here is a query to get the component count per App Monitor per Server SELECT [C].Application.Node.Caption as Node , [C].Application.Name As Application , [C].Application.Template.Name As Template , Count(*) as Components From Orion.APM.Component [C] Group by [C].Application.Name, [C].Application.Template.Name, [C].Application.Node.Caption Order by Components Desc
    • 4 downloads
  • Syslog & Trap widgets for Node & Interface Details Views

    Hello, I have prepared a full video tutorial for adding custom Syslog and Trap widgets for Node & Interface Details Views. You can also use below description and attached TXT file will all the queries. First Node Details widget will allow you to jump directly from Node Details view to Log Viewer Dashboard and start the log analysis: In order to create above widget, please add "User Links" widget and include below hyperlinks: Log Viewer (Syslog & Traps) - Last Hour /ui/orionlog...
    • 11 downloads
  • 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
    • 13 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...
    • 15 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.
    • 13 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.
    • 16 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.
    • 14 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.
    • 17 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.
    • 22 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...
    • 12 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,...
    • 34 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...
    • 13 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
    • 9 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...
    • 34 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...
    • 11 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.
    • 30 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...
    • 53 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...
    • 44 downloads