Shared Files for the Orion Platform
  • Backup Status by last backup date - Errors Only

    This report expands on ( or contracts really ) my previously published report, here: - as previously mentioned, we have had to do a join to pull in the node name, and now I've done a JOIN to custom properties to pull in the client prefix, and a JOIN to Orion.Nodes to pull back the status. This report only shows the nodes that generated an error and what that error is. This quickly allows you to identify the nodes...
    • 24 Aug 2022
  • NCM Backup Failures and Reason (- All Clients)

    Straightforward report that shows the last time a node tried to backup and its failure message. I also included the vendor and machine type so you can see at a glance if a particular model is causing issues. Due to our environment being large ( in excess of 10K nodes ) and covering multiple clients I have also done a JOIN to Orion.NodesCustomProperties so that we can pull in the Client and Client_Site custom properties. We then sort by client and client site. As you will likely not have these...
    • 27 Jul 2022
  • List of Reports

    Based on a thread, this is a starting point for a List of Reports in your SolarWinds installation.
    • 14 Jul 2022
  • Application Assignment

    Custom SWQL Report showing the created and update dates of applications (includes the nodes assigned to the element). Based on inquiry: Query view date created template SAM - Report Lab - The Orion Platform - THWACK - SolarWinds Community
    • 29 Jun 2022
  • 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