Shared Files for the Orion Platform
  • Serial Number report with various applicable OIDs

    Network device serial number report, with custom pollers created for multiple machine types and vendors
    • 18 Apr 2022
  • Custom Group Member Report with Node Information

    Saw a request elsewhere and wanted to help out. This report pulls group member (including child groups) which are Nodes. Then it pulls the list of interfaces for said nodes. This report is displayed in two ways (using the same query): Grouped by Group Name, then Node Flat
    • 8 Apr 2022
  • UnDP Custom Poller Utilization

    This report lists UnDP custom properties referenced in alert configurations, resources (widgets), and report definitions.
    • 8 Apr 2022
  • Custom Property Utilization

    This report lists all custom properties that have been created for all Orion Entity types. It's useful for deciding whether a custom property is actually being populated by your end users. For each custom property, it shows: The number of instances of this entity type that have the custom property set to any value except NULL or '' (empty string). The number of distinct values that have been used for the custom property, excluding NULL or '' (empty string) .
    • 28 Mar 2022
  • SolarWinds Orion Accounts

    Build based on a Feature Request. This may not be the "ideal" way to get the information, but it does work to pull the list of accounts. It's very wide. (Like very wide) Note: I had to guess for the SAML information because I don't have any SAML accounts or groups setup in my lab. SWQL is being the scenes doing the real work.
    • 21 Mar 2022
  • Yesterday's Windows Error And Warning Events

    Report showing the LA events yesterday, filtered for Windows Warning and Error events
    • 11 Mar 2022
  • Report That List What Alerts or Reports or Limitations are integrating a Custom property

    Report That List What Alerts or Reports or Limitations are integrating a Custom property On addition you can add on the query the condition with your known customer property to find Example: If I Change from SELECT TOP 1000 * FROM [dbo].[AlertConfigurations] Where [Trigger] like '%CustomProperties%' To: SELECT TOP 1000 * FROM [dbo].[AlertConfigurations] Where [Trigger] like '% CustomProperties|Region% It will display for me only the Alerts where the Custom Property Region is integrated...
    • 10 Mar 2022
  • Node Availability Report (By 'Nines')

    Based on the request from Uptime Report SQL query - Report Lab - The Orion Platform . This a complete report in SWQL which shows breakdown by "nines" (Five 9s = 99.999%, etc.). This is a very resource intensive report and may time out for environments with large date spans or an incredibly large number of nodes. Defaults only give this report for the last 7 days ( not the previous week). Customization options are also included in the report if you'd like to make changes. Some of this work...
    • 26 Feb 2022
  • Device Port Inventory

    Connected Device Information Two ways Grouped by Node, then Port Dump of all data
    • 22 Feb 2022
  • Node outages for the last day with duration

    Report lists all node outages occurring within the last day, showing start/end time of the outage and total duration in minutes. Sample output:
    • 15 Feb 2022
  • Report for Lightweight APs on Cisco Controllers using Custom Pollers (UnDP)

    A report for people using custom pollers on Cisco WLAN Controllers to get some info ;-) This report came with some help from a post I found on Thwack (Thx mesverrum ) Hope you enjoy this.
    • 15 Feb 2022
  • Group Member Availability Report (Hourly/Daily/Monthly)

    Simple report that shows member availability broken down by group and then by time series. Currently this is only functional for group members which are nodes. Could be extended in the future to include Interfaces, applications, etc., but elected to keep this version simple.
    • 11 Feb 2022
  • VMware Host Disks

    Pulls a point in time report for Virtual Disks in a VMware Infrastructure. Added disks from Hardware Information as a second table.
    • 31 Jan 2022
  • VMware Inventory Report

    List of Servers and where they live in VMware vSphere, cluster, and host.
    • 12 Jan 2022
  • Reboots and Downtime Report (Last 7 Days)

    Updated to include Availability from Orion.ResponseTime , calculated Availability (based on minutes down from Orion.NetObjectDowntime ), and the number of 'Node rebooted' events from Orion.Events . It was inspired by a question posted on the Network Performance Monitor (NPM) Forum . There is plenty of details in the query about how the information was calculated. There's also a mention (commented out) on how to add filters for Node-based custom properties. Important Note: There will be...
    • 6 Jan 2022
  • Get all SVIs with their IP addresses & Descriptions (need NCM)

    Report to get a lot of info on SVIs configured in your network (tested with Cisco devices). Columns in the report: Hostname (systemname), Interface, Description, IP Address & Subnetmask SWQL query can be altered / expanded to use CPs (ex. Region, ...)
    • 4 Jan 2022
  • Enabled Alert Query Details

    This Report breaks apart your Alert Configurations. Timing, Scope, Trigger and Reset Queries. Translated to simple text without cracking open each alert. I'm still working out the XML rebuild for proper structure but at this time operators get shifted to the 'end' of the equation portion where it sits. There will be an effort to revisit the data rebuild in the report to better align the equations. And don't be fooled by a trailing AND that may be present in the trigger details. It seems to be...
    • 29 Dec 2021
  • Server Memory & CPU Report (by Manufacturer/Model)

    Inspiration: I need a report of total RAM and Percent Memory Used - Forum - Server & Application Monitor (SAM) - THWACK ( Can be filtered by editing the data source on the second table. Requires Asset Inventory to be enabled for Server & Application Monitor (SAM) .
    • 17 Dec 2021
  • Weighted Average Availability

    This report uses a weighted average to calculate node availability. This may be useful in circumstances where you may prefer to configure the maximum weight to filter out records that happen after the polling marks the node down or the node was unmanaged. This report should be used with detailed response time records only as hourly and daily records will be aggregated using normal averages. For more information on how Orion calculates Status and Availablity visit https://documentation.solarwinds...
    • 2 Dec 2021
  • Node Availability - This Year

    This is a replacement report for the Out-of-the-Box report of the same name, written purely in SWQL in the hopes that this would render faster for large ecosystems. There is only a slight uptick in rendering this report on my system (about 9%), but I only have about ~130K records in the Orion . ResponseTime entity. In the event that you have a significantly larger infrastructure you may want to add additional filters beyond the ones I have in the SWQL Query (like Availability is not 100% or...
    • 5 Nov 2021