Media Gallery - File List
  • Interface Count Monitored by Node Name

    Interface Count Monitored by Node Name
    • 25 Jul 2018
  • Volume Count by Node Name

    Volume Monitor Count by Node Name
    • 25 Jul 2018
  • Acknowledged Alerts

    An example report, to show the last 7 days of acknowledged alerts and who acknowledged them, with the notes they made. SWQL based, from the AlertStatus table.
    • 9 Jul 2018
  • SNMP traps from SQL query example

    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...
    • 5 Jul 2018
  • When Was Database Maintenance Last Performed (Exported Report) - Prosperon Networks

    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...
    • 5 Jul 2018
  • Down nodes - demo report

    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.
    • 22 Jun 2018
  • Dependencies Status Report

    From Karlo.Zatylny ​'s work in the following thread NPM 10.1 Dependencies Status Report
    • 29 May 2018
  • Response Time vs Packet Loss Last 30 Days

    This report is based on Deltona work posted here > Re: Repporting on Historical Percent Loss and Response Time
    • 23 May 2018
  • Alert Action - Email Assignments

    This will report out details of alert actions with email assignments
    • 20 Apr 2018
  • Interface Count by Node Name

    Count Of Monitored Interfaces Per Node
    • 12 Apr 2018
  • Orion NPM HW HEALTH REPORT FOR NODES WITHOUT SENSORS

    Here is a report that you can import into Orion to list all Windows NODES that do not have a HardWare Health Sensors being monitored. ** Attached report import is at bottom of this document ** Reference also : https://support.solarwinds.com/Success_Center/New_Articles/Report_HW_Hardware_Health_Node_not_being_monitored%2C_missing%2C_Null%2C_empty. Document on how to create this ... Steps to create a HW Health report to show nodes without any Sensors This file contains all the steps and information...
    • 29 Mar 2018
  • VMs Not Monitored In SolarWinds Orion (Exported Report) - Prosperon Networks

    In order to accurately monitor the virtual machines in your environment, it is beneficial to combine two different approaches. Firstly, monitoring guest servers through the physical host, and then monitoring these servers directly using WMI, SNMP or agent. This combination allows you to identify the cause of performance problems from two different perspectives. Polling through host systems allows you to monitor the basic resources for all virtual servers, as this approach shows information for all...
    • 26 Mar 2018
  • Interface created Today Database query

    The following query will check the and report which Interfaces where created base on earliest detailed record reported. The 'daysback' variable will check a specific day minus today.  ie; today - 1 = yesterday. Here is a Query sample output shows Node+interface (fullname) date-searching for & converted to an Int, and firstPolled date & time :     fullname nodeid interfaceid searchdate searchdateG firstpolleddt firstpolled cur-3550 - FastEthernet0/2 · test 141 641 3/1/2018 43158 3/1/2018 11:31:33...
    • 1 Mar 2018
  • Node Availability Report (Up / Down)

    We’ve prepared a custom SQL query to reports node availability for last 30 days 30 days Node Availability – shows outage duration in hours and mins for each node and uptime
    • 20 Feb 2018
  • Cisco Adaptive Security Appliance Remote Code Execution and Denial of Service Vulnerability (v3)

    In response to https://tools.cisco.com/security/center/content/CiscoSecurityAdvisory/cisco-sa-20180129-asa1 Currently this report only shows ASA firewalls, but the query can be quickly modified to include Firepower appliances as outlined in the thread. Updated for latest Updates.
    • 30 Jan 2018
  • User Role Delegation

    Based off this Thread - Need a report to show NCM user role for user accounts
    • 29 Jan 2018
  • All Unmanaged Nodes

    All Currently unmanaged devices + time period. States when, For how long, What time Remains, a Time/Date stamp (From-Until), and by what account. EXAMPLE: Node When For Remains From Until Account SolarWindsNode1 10 days ago 21 days 11 days 09/06/2017 6:48:45 09/27/2017 12:00:00 SolarWindsUser1 EDIT: Retested and confirmed a working SQL Query. Tested on NPM 12.1.
    • 13 Dec 2017
  • Ghost & Unknown Interface Report

    I have posted this in some threads but never uploaded it for easy finding.  This is a report to show your ghost and unknown interfaces so you can either update credentials to bring back to life or delete when the interface is old. -CharlesH Loop1 Systems: SolarWinds Training and Professional Services LinkedIN: Loop1 Systems Facebook: Loop1 Systems Twitter: @Loop1Systems
    • 28 Nov 2017
  • Historical Alerts - Last 24 Hours

    The report shows information on alerts triggered, whether still active or not, and other associated information, such as who acknowledged the alert, and related node.
    • 21 Nov 2017
  • Last Month's Interface Availability Report, Including % available, up and down time

    Last Month's Interface Availability Report, Including % available, up and down time. Based on Orion's polling data, so if it misses a poll, 100% may not equal to whole month's time.
    • 16 Nov 2017