Media Gallery - File List
  • 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 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.xml

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

    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                 9/6/2017 6:48:45 12:00:00 AM      9/27/20177 6:48:45 12:00:00 AM       SolarWIndsUser1
    • 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.xml

    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
  • Current+users+logged+into+Orion.xml

    A quick report to show the current users logged into Orion.
    • 28 Sep 2017
  • All Configured Alerts Inventory Report

    This Report is a new and improved version of the out-of-the-box 'All Configured Alerts' report. This version is written in SWQL rather than SQL and supports user account restrictions.
    • 5 Sep 2017
  • [Report] Devices Not Responding To SNMP, WMI Or Agent Queries

    It is quite common to have devices populated in your SolarWinds installation that were monitored using SNMP or WMI, but due to some ACLs or firewall changes or maybe because of credentials changes, SolarWinds can’t poll any statistics from them anymore. What is the main problem with this? The issue here is that if SolarWinds can still ping the device but can’t get any statistics using those protocols, the SolarWinds web console will not display any issue with those devices - they will still be green...
    • 8 Aug 2017
  • 'Node Rebooted' NPM Events History - Last 3 Months

    'Node Rebooted' NPM Events History - Last 3 Months This report can help in seeing whether there is a trend of continuous reboot cycle on monitored 'non-ICMP-only' & 'non-External' nodes. This report looks into the Events table for entries of the 'Node Rebooted' event type. It will show you the Node Name, the time stamp when the node rebooted event was detected, and the message content of the entry in the NPM Events table. It is Ordered by:Node Name - Ascending then by Event Time - Ascending, and...
    • 19 Jul 2017
  • Total Nodes, Volumes, Interfaces, NCM Licensed Nodes and UDT Ports Used by Group.xml

    Total Nodes, Volumes, Interfaces, NCM Licensed Nodes and UDT Ports Used by Group.xml
    • 22 Jun 2017
  • Windows Event Logs Report

    Updated version of the Windows Event Log Report now leveraging time stamps and using SWQL instead of SQL.
    • 10 May 2017
  • Syslog from Unknown devices

    Staff normally remember to configure the syslog servers (as it is in the template configuration), this acts as a check that staff updated the CMDB it declare systems as being deployed.
    • 22 Mar 2017
  • Assigned Poller Report

    Report will show pollers assigned to devices and which devices have no pollers assigned. This is specific for Juniper devices but that can be easily modified after you import the file.
    • 1 Feb 2017
  • Deletion Report

    Have you ever worked in NPM? Have you ever deleted anything? Ever wonder if anyone else deleted anything? Here is the report for you! Its very simplistic but I couldn't find another existing one so I started here. This report is limited by your Polling Settings for your Auditing Trail Retention so the longer that is, the more history you'll have. YMMV.
    • 26 Jan 2017