lag ✭✭✭✭✭

~~ 6 Aug 11:32:22 ntpdate[6324]: adjust time server 206.108.0.132 offset -0.051731 sec ~~

Yes - basically that, but in TSQL. In that inner select, you'll want to join your volumes table so that you can filter on the volumetype. ... JOIN Volumes ON VolumeUsage.VolumeID = Volumes.VolumeID ... AND ( Volumes.VolumeType = 'Fixed Disk' OR Volumes.VolumeType = 'Network Disk' ) ____ or to modify my first example ____…

Device shows correct vendor in NPM, but Unknown in NCM SysObjectID (which you can find in Node Details) in System Manager. sysObjectID.01.3.6.1.4.1.23867.1.2.3 Name/OID: sysDescr.0; Silver Peak Systems, Inc. NX3500 Linux SP-Chelmsf​ord 2.6.22.14 hidalgo 3.3.1.0_32​873 #1 2010-08-17 16:48:54 SMP x86_64 Vendor: Silver Peak…

10.7 at the moment. (I've been delaying the 11.5 upgrade until the next NCM is released.)

Were you able to get this resolved? I'm experiencing the same thing, and hoping you might have found an answer.

Thanks for the tip. I've tried it using a local account on the server, and an Orion non-AD account, and I'm still not getting anywhere.

Thanks, that's great news. I'll put it into the lab and see how it looks.

I must have missed that. I'm betting that DeleteActionsByAssignments is what I'm looking for.

From the Sproc, the number is a Count(This_Is_a_primarykey). I'm assuming the count is presenting itself as an int. I'll try to force the format and see what happens.

Did you find a solution to this problem? I'm bumping into this as well with some RHEL 7.2 servers while trying to use the SNMP process explorer.

The first query would let you convert UTC to local timezone, which would be local to Orion (the conversion is happening at Orion before sending out the message as an alert trigger action). I _believe_ if you are building a report using the conversion, then the date is converted to web user local. <- I 'think' this is true…

Stored Procedures are stored queries in the Database. They are precompiled. When you request database to execute a stored procedure (SQL Server), SQL server already has the execution plan for the stored procedure. While simple queries need to create their execution plan on run time. You can find arguments that say they are…

... Select Volumes.VolumeID, Volumes.FullName FROM Volumes _____________________________________________________ (Entering the below, should work - Change your thresholds accordingly) _____________________________________________________ JOIN Nodes ON Volumes.NodeID = Nodes.NodeID JOIN( SELECT NodeID ,VolumeID…

We'll be there very soon. I'm waiting on some new hardware for our primary engine before pushing the upgrade, and then bringing the rest of the hosts up to snuff. I'm hoping to have this all wrapped up before the end of October.

At the moment, I have 11 including my primary engine. The core of Orion is in a DC in Houston, three pollers at a DC in Dallas, and one poller in Minnesota. We have a growing AWS environment, and I’m in the middle of planning an on-boarding exercise for 5 data centers and some additional offices of various sizes that may…

We had to delete all the ProgramData/SolarWinds after uninstalling the agent, then reinstalling the agent worked again.

Not sure if this will work, but you might also try ${Node.MachineName}. There are some places where that works where you would expect the usual table name of Nodes should work...

This is possible using a custom script monitor. I'm a fan of using powershell to grab this with a Regex match. Something like Get-Content, match a string, and then do some work with it to provide feedback to SAM. You'll want to have at a minimum a Statistic and message, and you can use Exit codes as well. I believe exit…

Sorry, forgot to add "group by nodes.caption, nodes.nodeid" at the end like so: Select Nodes.Caption AS "Node Name", Nodes.NodeID, Count(Events.EventType) AS "Count" From Events Inner Join Nodes on Events.NetworkNode = Nodes.NodeID Where Events.Message LIKE '%Memory Alert: %' AND eventtime between dateadd(month, -1,…

Here's a snap of how the alert condition would look. screencast.com/.../f9PoU01T1s Although, I would recommend starting out with a report to see how widespread your problem is before triggering an armload of alerts. An advanced SQL report would be easy enough - If you include the nodeid in your query, you'll get a link to…

Generally I'm looking for the message type being sys-5-config_I. There may be variations, though, depending on how you exit. The best way to make sure you'll capture the correct event is to generate the message and match the filter rule to the message. Adding/changing a description on an interface is a pretty harmless way…

Top XX Proceses by Processor Time - PoSH Monitor

Lots of this: 2020-06-07 18:15:37,860 [140599006472000] INFO job_application - Starting poll of component 184615 (Up Time) 2020-06-07 18:15:37,868 [140599006472000] ERROR job_application - Traceback (most recent call last): File "/opt/SolarWinds/Agent/bin/Plugins/SharedPythonLibs/pypyodbc.py", line 427, in <module>…

The SILI coding or naming convention is critical. One other thing that I've found very useful is to include the alert name in the message body of the alert. If you have more than a handful of alerts to manage, this will be very handy. When configuring alert messages, take advantage of the HTML formatting. You can…

Is your script vanilla enough to share? I'd like to take a look at it since we're going through the preliminary steps of SNow integration today.

"Understanding of what you NEED to monitor! It's pointless monitoring something just because you can, every node, ever device has to have a reason to be in your Orion database, otherwise it's just taking up space." This one is an easy pitfall to fall into, and hard to talk people out of.

Rumor has it that you can barter the more advanced queries and scripts with beer. ...Although what I'm really saying is make a friend in these departments. I love figuring this stuff out for myself, but sometimes it's nice to get an assist when you get stumped.

You can monitor the RAID status, but you'll need to set up a custom poller (Universal Device Poller). It varies for different vendors. For example, for Dell, you will need to have OpenManage on the server, then you can set up a custom poller to collect array state (which I think is 1.3.6.1.4.1.674.10893.1.20.130.4.1.4).

What version of NPM are you running? We're currently running NPM 10.7, and I was asked to upgrade to the latest release before a ticket could proceed. I plan on upgrading this quarter, but I have to jump through the standard hoops first. I'm also sort of waiting for 12 to release so I only have to run through the upgrade 1…

Dave, Use the Universal Device Poller tool on the Orion server to find, test, and assign the OIDs you want to trigger alerts with, then build the appropriate alert using Advanced Alerts. In the alert you will want to define both the custom poller you assigned, and the desired value (rate, total, etc...) in your trigger.…