RichardLetts ✭✭✭✭✭

You will have to provide an aggregate function of some kind to get the information: SELECT COUNT(Events.EventTime) AS COUNT_of_Event_Time,Min(Events.EventTime) as From_Time, MAX(Events.EventTime) Until_timeNodes.Caption AS NodeNameFROMNodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType =…

It is at this point, some months later that I post a Mea Culpa -- I know why the polling load on two of the servers is only half of what it should be and after correcting the issue I'm seeing polling loaded broadly in line with the number of elements on them. [I had effectively stacked licences on two of the servers…

I make use of Trap Receiver running on a server to receive a 'trap' from the alert manager and explode it to workstations in the NOC; they have the same program running that then fires a local action (in my case I have a WebMail Notifier | Dream Cheeky stuck on top of some monitors, and I blink it different colors.)

Adobe? I've turned it off because it crashes our browsers which is annoying as heck.

Settings -> Web Console Settings -> Enable Audit Trail note: if you have the audit-trail resource on a page it is only displayed for system administrators -- so I and the other admins get to see the audit trails, but regular users do not.

orioncrack wrote: Also, tickets I open with an obvious defect or bug they get closed without any kind of "we're going to fix this" acknowledgement on Thwack, a KB article or in the ticket closure notes. This I do find annoying. I often report bugs that I can work around. I don't see why fixing bugs has to be filed as an…

What will the performance of dependency handling be like (I have tens of thousands of dependencies I would like to create) => I think it's a good idea for the SDK to give hints about things that could cause performance issues on one's Orion installation.

Please read more on how a MPLS network works because you have some invalid assumptions in your comment. In much the same way that VLANs virtualized a switch infrastructure MPLS virtualizes a router infrastructure In much the same way as vmWare virtualized hosts onto server hardware VRFs (part of MPLS) virtualized the…

xtraspecialj wrote: Also, this never bothered me until a co-worker pointed it out, but they need to fix the fact that when managing interfaces with Manage Nodes you can't group by Interface properties (same thing if they add volumes to the Manage Nodes drop-down) and the only Interface properties you can add as a column…

I'm going to suggest you spend some time learning SQL. It will not be wasted. Understanding that databases are behind almost every application today helps you understand how and why they work. Without the actual data in a sqldatabase I can't write the SQL: I write what I think the query is, I test it against actual data, I…

This will take a small amount of testing, try ${VbData2} and see which value is returned. (they Varbinds are displayed in the order received.) Alternatively read Traps to Alert Conversion using custom SQL queries for how to do this without using tags

this is a gigabit interface running at 100Mbps ( Full-duplex, 100Mb/s, media type is 10/100/1000BaseTX) If you get burst traffic above 100Mbps outbound on this interface you will get transmit discards. (I'm not familiar with these switches, but I'd look at why the interface is not negotiating to a gigabit and then outbound…

Do you have VRFs? -> with snmpv2 the community name is prefixed by the VRF-name to give the VRF-view of the data (e.g. the ARP subtree is per-VRF instead of per-router) do you know how that changes for the snmpV3? answer: use the context: Identifying a Routing Instance - Technical Documentation - Support - Juniper Networks

yes my screenshot is from the new web-based alert manager, but that actual alert was created in the advanced alert manager (and migrated when we went to 11.5.1)

Step1 for me is upgrade the database server

this is the crux of why we've not been able to turn down completely our old stats collection: Solarwinds NPM has this predilection for deleting data and we need to be able to retain historical statistics.

We have UDT and a very large environment. what happens is one wizard drops an index, and another wizard creates the same index. This creates deadlock in the database, no matter how fast your DB is.

Yep, reported that bug with UDT 3.1 to solarwinds too. I'm almost certain that no-one in their QA or usability teams actually runs network sonar discovery.

Unless you allow the Alert manager service to interact with the desktop I do not think that it will startup notepad successfully We have no idea if the command you actually want to run also needs to interact with the desktop -- you obscured what you were actually trying to achieve. How do you know the application didn't…

I would get the TCPConState table do a gettable on tcpConnState.<localIP>.<localport>.<remote-host-ip> and then check for an established connection e.g. on the switch with IP address a.b.c.d there is an established connection to ssh (port 22) from the host w.x.y.z from a random high port (38643)…

Solarwinds orion has: Application server / Main poller -- shut the services down here Additional polling engine -- shut the services down here of you have one Additional web server -- personally I'd shut these down too if you have one It makes use of a MS SQLserver -- leave this up. and, yes it's much quicker than…

${AlertDefId}-${ObjectId} will also be unique an active alerts, but between alerts on the same object if you want to can use some key for the Alert Definiton, e.g. ND-${ObjectId} for all node Down alerts (but all node down alerts for the same object will have the same key, or you could add a timestamp)

[I use perl + SWIS because the API just works, I've been writing perl code for over 20 years, ] yes, separate calls. :-( $poller is one of the strings I've never had AddPoller fail -- it feels like there is no error checking on the server-side for Create operations given a valid nodeid. I seem to remember that it will add…

Encryption between NPM and MS SQL DB servers (note: the original posting was from over 2 years ago so, back then: yes it's unencrypted; today: depends on the version of NPM you are running, and if you have enabled it.)

something did not get installed correctly. last time this happened to me support set some value in an XML file and re-ran it to cause the installer to reinstall all of the files.

I'm not running a later version of NTA -- we're looking at alternative netflow products so it does not make sense to install a new server to support the 4.x release OK, in my experience I (now) never upgrade more than one product at a time. I've done more than one at a time in the past, and that always seemed to lead to…

I don't bother balancing across APE -- there is not much point, and it does not get you anything (assume they both have about the same power and capable of supporting the full load). In my environment we have almost nothing on the primary polling engine -- that server is dedicated the the WEBui, syslog, traps, and Netflow…

step 1: colour the trigger and reset traps differently so the start to look like this: OID for 'TCP Connection Cleared' clear: [you pasted images instead of text, so I just used color fill from paint making these look ugly, but hopefully you get the idea.] putting the combination of things to match in the 'tag' sounds like…

Status is not the same as the rate column... e.g. RateTotalRawStatusStatus3.900397337334239392.2002241610231722228.10082537292581810.600061146907664.100417613859464141 I'm not sure what the CustomPoller tool shows you (it crashes on me when I try to look at values -- too much data) try running this in the Database Manager…

if the roll-up for the group is set correctly (to 'worst ' status) then one member being down will set the group to being down. /RjL