zackm ✭✭✭✭✭

I would recommend using the Unmanage Scheduling Utility to create a recurring task to unmanage those specific nodes for 30 minutes. If they are still in a down status after the unmanage window, they would then trigger that alert. Unmanage Scheduling Utility -ZackM Loop1 Systems: SolarWinds Training and Professional…

Try this out: SELECTCONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),101) AS SummaryMonth,Nodes.NodeID AS NodeID,Nodes.Caption AS NodeName,AVG(ResponseTime.Availability) AS AVERAGE_of_AvailabilityFROMNodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)WHERE( DATEPART(dw, DateTime)…

Try this out: Devices_and_Objects.OrionReport -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

Congrats! <insert witty comment here, I have 2 littles myself and last night was rough!>

I would suggest using the web report writer and simply adding an additional table (add content button) that has the full summary information on it. There's not a good way to run it all in one table outside of taking your raw data into excel and then doing your math outside of the report, so to speak.

Here's a decent overview with a follow-up link for least-priv modeling: WMI requirements for SolarWinds accounts - SolarWinds Worldwide, LLC. Help and Support

The easiest way would most likely be to mark your MPLS interfaces with a custom property and then modify an existing utilization report to limit results to only interfaces where "Node.CustomProperty.MPLS = True". example: From your SolarWinds website: Home Menu > Reports > Manage Reports > Add Report - From here, select…

My gut reaction would be to: 1) Open a Feature Request to add "Failover Status has Changed" as an event for F5 devices in the web alert engine. (Network Performance Monitor Feature Requests) 2) Use SNMP Traps to alert on failover events in the interim (Monitoring Active/Standby failover) If you do open a Feature Request,…

can you post the full query you are using?

You're probably going to need a custom SQL query for this. Easy enough to do if there is only 1 poller per device for these values. What are the exact poller names for these 2 data points? Your basic SQL query will look something like this: SELECT Status FROM CustomPollerStatus WHERE CustomPollerAssignmentID IN (SELECT…

You can monitor uptime through SNMP, with the caveat that the uptime is really a measure of the SNMP service, and not the entire server (last I checked anyway, someone please correct me if I am wrong) SAM (Server and Application Monitor) will undoubtedly have some solid functionality for this as well.

Can you post your current SQL code to see where your starting point is? I am 90% sure I know how to get this straightened out for you, but need to see what you're working with first. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter:…

I don't think so. Even the job itself in the DB is in XML, which would not be easy to get to either. This would be a nice feature request though. If you make one, please post a link here so we can vote it up!

out of 73 nodes; we have one that seems to be affected. 2 members up for 49 weeks WS-C3850-24S-E IOS Version: 03.07.01.E RELEASE SOFTWARE (fc3) IOS Image: CAT3K_CAA-UNIVERSALK9-M of the 72 unaffected nodes: uptime from 1 week to 98 weeks 35 others have the same IOS Version all 72 have the same IOS Image

This should do the trick for you. All of the following is based on NPM polling, no NCM data is being used here. First, you want to use the Web Report GUI to create a new report and setup your datasource to look for any Interfaces that have traffic and are either Up or Down. Then, you want to edit your table colums as such:…

You might take a look at enabling either Real Time Change Detection, (and) or the Config Change Approval process. RTCD will notify you via email on changes and show what exactly was changed in the configuration. Config Change Approval will allow you to setup a process where users must have their scripts reviewed before…

From your primary server: <install dir>:\Program Files (x86)\SolarWinds\Orion\Reports and if you have NCM installed, those are here: <install dir>:\Program Files (x86)\SolarWinds\Orion\NCM\Reports - ZackM http://www.loop1systems.com

This should take care of that for you. Using the web report engine, you would just setup a simple query as such: Then you can add whatever columns you want to your table. Hope that helps! -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter:…

You may need to play around with an f5 to see which particular status is the one you need to trigger on, but I *think* the Orion Status would be your best bet for the LTM Server. Screenshot from NPM 12.1

cahunt should be right on the money there. however, I would recommend actually assigning values to your 'Ignore_Disk_Alert' custom property. There is a big difference between a NULL value and an empty value with reference to MS SQL.

Can you expand on this? Which module of SolarWinds are you using? What alerts? Are they directly from SolarWinds or passed through Alert Central? More details please. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

Off hand, I would say go a step up and change the condition to 'when NONE of the following are true'

you have to use timestamp limitations in your datasource: -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Loop1 Twitter: @Loop1Systems * ZackM Twitter: @ZackM

The commands should be coming from the assigned device template. If you have it set to auto-assign, it will pick up the device template with an OID that matches your firewall the best. To review the commands, you can look at the files in this directory: C:\Program Files (x86)\SolarWinds\Orion\NCM\DeviceTypes More specific…

A few jobs back, I was on a contract with a federal agency where it seemed that the #1 threat was internal problems with Layer 8. However, there were also constant attacks from outside in the way of email phishing. So it really depends on where you define the problem. Is it the fault of the malicious, or the fault of those…

At a quick glance, this looks like it is a last 30 days report. Line 5 is the 30 day mark; used in line 8 to setup the @endTimeT1 variable to getdate()-30 DECLARE @Today DATETIME = GETDATE()DECLARE @startTimeT1 DATETIME;DECLARE @endTimeT1 DATETIME;DECLARE @intFlag INT;SET @intFlag = 30SET @startTimeT1 = CAST(getdate() AS…

You can try running an HTML iframe against the DirectLink account: Using the DirectLink Account

ASSUMPTIONS/DEPENDENCIES: * All of your endpoints need to be in NPM inventory * All of your endpoints have a True/False custom property called "Wireless" SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS NameFROM NodesWHERE Nodes.Wireless = 0AND Nodes.NodeID IN (SELECT NodeMACAddresses.NodeID FROM…

that's an interesting idea... something that would definitely be good for a feature request. You might try this in the Report Writer application and then you can embed this in a view using the 'Report from Orion Report Writer' resource. SELECT VI.VOIPOPERATIONINSTANCEID ,VT.OPERATIONTYPE AS 'OPERATION TYPE' ,CASE WHEN…