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...
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...
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.
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...
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...
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...
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.
All Currently unmanaged devices + time period. States when, For how long, What time Remains, a Time/Date stamp (From-Until), and by what account.
10 days ago
EDIT: Retested and confirmed a working SQL Query. Tested on NPM 12.1.
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.