zackm ✭✭✭✭✭

This is one of those few places in life where I wish people would just assimilate... (One of Us) With the tools available, and the relatively TINY file sizes you are placing on storage, there is just not a reason to NOT back things up. Yet I see it so often that it's mind boggling. Perhaps it's just that before a company…

#THWACKCamp #bumpsqaud​

It was discussed, but this client (and some of my previous ones) would much rather have their organized system versus dropping everything into one flat folder. This is what most ask for, at a minimum. The ultimate request is to provide the ability to select certain tasks via check box, whilst still keeping their folder…

My $0.02 - One thing this job has taught me is that there is always a client that wants more and generally they have a very justified reason for their request. I would LOVE to see resources in general start moving towards the "more is more" concept. While option 3 above might cover the needs for 90% of clients, why limit…

I completely trust my wife because she told me that I do.

HUGE NetFlow fanboy here! I absolutely love the technology and can sit in a room of whiteboards and discuss architecture and design ad nauseam. <soap box> That being said, one thing I keep seeing over and over at different clients is duplicated data. In most environments, there isn't a technical reason to not grab both…

The one that I always refer back to is a former coworker that spent a good 5 minutes arguing with an instructor that ICMP used UDP Port 161... He graduated to customer within a month or so after that one. There were a multitude of transgressions, but that argument is sealed in my mind forever as one of those…

backup-ception.

That's an EXCELLENT point that you really can leverage these tools more with a solid understanding of what 'normal' is for your environment and how the devices interact with each other. Kudos.

sounds great! please do come back and share your results with everyone uniswtc​!!!

Actually yes! New Zealand typically switches about a week after everyone else. So they are observing DST on 4/2/2017

Got it. So, when you check the "Synchronize Across Time Zones" option, what that is actually doing (which the GUI is horrible about signifying) is switching your schedule to respect UTC. When the box is unchecked, the schedule respects the local time of the server the task is running on. The trouble you're going to have is…

not off the top of my head. try throwing your alert info in the https://thwack.solarwinds.com/community/labs_tht/alert-lab and see if someone has some time to look at it for you.

looks like your alias is causing that one "Select NodeID" needs an alias, it should be either dv.NodeID or p.NodeID (whichever you want to limit on)

This thread is a little hard to follow; let's recap: Is the intent to unmanage nodes on the 2nd sunday of the month for X amount of time, no matter where the actual nodes are in the world? If so, what is the local Orion server time zone, and what are the target node time zones?

did you get this part figured out? ($swis propogation)

That's really the trick isn't it? If the IDs are not supported as variables, then off the top of my head I am not sure you could. You have to be able to join the NodeID pulled from the alert to the pool ID. (Since there are multiple pools per nodeID, this really isn't that simple at all unfortunately) In the clients I have…

you can test all of this is SQL Server Studio Manager (or SolarWinds Database Manager if you prefer) SELECT * FROM F5_Device_V JOIN F5_Pools on F5_Pools.NodeID = F5_Device_V.NodeID Start with that, it will list out all of your F5 Devices and Pools being monitored.

Try this: WHERE CustomPollerStatusTable.CustomPollerAssignmentID = 'e9XXXX2f-0488-4XX4-9XX7-ca3eXXXXX2bb' AND CustomPollerStatusTable.RowID = '20' AND CustomPollerStatusTable.Rate >= '50'

As people have said before, NCM is not designed for monitoring via SNMP at all. It is a Network Configuration Management module. If you want to alert on volumes, then you need to use the correct product to do so. In your case, you should look at NPM, which can very easily do all of the things you are doing above in your…

Just like this: The limitation doing it this way would be that your alert object is a node and not a row in your tabular poller. You could probably create some SQL variables to go with your email to give you details on the actual rows with problems. But that's only after you verify that this would even work based on the…

it would be something like this (forgive small mistakes, I'm mobile right now): NODES: SELECT old.IP_Address AS 'oldIP' ,old.Caption AS 'oldNodeCaption' ,new.IP_Address AS 'newIP' ,new.Caption AS 'newNodeCaption' FROM OldSolarWindsDatabase.dbo.Nodes AS old FULL OUTER JOIN NewSolarWindsDatabase.dbo.Nodes AS new ON…

You are correct. LastSystemUpTimePollUTC is not filled with ICMP polling. Try this (the issue really lies within the need to also have ICMP nodes in your report, it makes this a lot more difficult) Current Down Nodes and Interfaces with Duration You could also easily create a report based on your alertstatus table that…

That's a good question, and the answer is (generally) "it depends" Without having anything indexed, it's really up to the optimizer to figure that out for us. Here's a quick little explanation I found years ago and bookmarked just to reference these questions.…

It would return only the servers missing both C and D

Here you go. This should only return the newest running config. SELECT n.Caption as 'DEVICE' ,n.IP_Address as 'IP ADDRESS' ,n.VENDOR ,n.MachineType as 'MODEL',MAX(c.DownloadTime) as 'DOWNLOAD TIME' FROM Nodes n JOIN NCM_NodeProperties p ON p.CoreNodeID = n.NodeID JOIN NCM_ConfigArchive c on c.NodeID = p.NodeID WHERE…

try this. advanced alert manager > custom sql alert > f5 device type (top half is built in, you need to copy/past from the 'join' down) SELECT F5_Device_V.NodeID AS NetObjectID, F5_Device_V.Caption AS NameFROM F5_Device_V---------------------JOINF5_Pools ON F5_Pools.NodeID = F5_Device_V.NodeIDWHERE…