RichardLetts ✭✭✭✭✭

This is the Message Broker used for inter-process communication between the Orion components... this message is interesting: https://groups.google.com/forum/#!topic/rabbitmq-users/UCQ5RXp1ExM I'd suggest opening a support case on this. /RjL

Yes, I've seen that for a start the NODES table has been split into three, so what I'm seeing is fewer processes backloging on update/locks on that table while tryin to read the nodeid/caption/static information. I am still seeing a load of deadlocks though -- killing some of the transactions which cannot be good for…

Use a custom SQL alert on the node and some SQL like this: WHERE NODEID IN ( select NODEID from traps INNER JOIN trapvarbinds tv ON traps.trapid = tv.trapid WHERE traps.traptype = 'BGP4-MIB:bgpTraps.0.2' and traps.DateTime < dateadd(hour,-1,getdate()) AND acknowledged = 0 AND tv.oid LIKE '1.3.6.1.2.1.15.3.1.2.%' AND…

database table orion.websites

It does not -- your account only needs rights to read the object you are accessing; I'm going to guess this is there as a blanket statement so Solarwinds doesn't have to document and deal with someone doing odd things with access rights. [My regular AD login is also the manger of the groups I'm adding to Orion, so it works…

I've put an idea out there to split the Wireless polling features into separate pollers so we can turn off some of the things in NPM (we have AirWave for heatmaps -- it's database server makes the NPM database look puny by comparison) The reason not to bundle everything into one poller is because We can't get NPM to…

We have two physical servers for Solarwinds products today which include NPM, SAM, and NCM. The system is under a lot of load and we are looking to upgrade. Could you quantify what you mean by under a lot of load: are you seeing the system running at 100% CPU, Swapping, or bottlenecks writing to disk? Main application…

The best way to do this is to: a) send traps from your routers to Solarwinds for BGP events [that depends on your model of routers and persuading your sysadmin to send to the data directly] b) add rules to the TRAPviewer to TAG traps for BGP backward transition (see idea http://thwack.solarwinds.com/ideas/3023 for the…

just the opposite experience to previous upgrades -- perhaps you have some underlying issue. what does support say? have you run diagnostics?

Network Elements30026Nodes5635Interfaces24362 plus: Wireless APs: > 9,100 Spread across 4 polling engines polling at the defaults.

I'm going to suggest that if you have a modern install you probably want to have an always on SQLserver cluster replicating across the two locations -- this is normally setup by DBA, but it's fairly simple for mere mortals to setup. The Solarwinds HA product will (does) work in a WAN environment, and if you have Dynamic…

are you gathering layer-3 information from the switches? if so, try turning it off may help -- SWO is using the IP<>ARP tables for connection rather than the bridging tables. I had the same problem with routers and switches across our northernwave network where internal management interfaces were being shown as connected…

rediscovery: only on the non-monitored interfaces (if the polling IP changed the rediscovery will not be able to reach it) discovery: no idea, do not use (IMNSHO this is the single most pointless function in any network management application)

Yes (and yes, MSMQ is needed) here's the document: http://www.solarwinds.com/documentation/Orion/docs/SolarWindsPortRequirements.pdf /RjL

any valid sql server select statement that returns a single column and row works Here is an example using substring and an xmlpath trick to concatenate rows into a single comma-delimited list ${SQL:SELECT A.peerip + ', ' AS [text()] FROM (SELECT DISTINCT Substring(tv.oid, 22, 20) peerIP FROM traps INNER JOIN trapvarbinds…

yes. Use the following alerts and UnDP if you want to use the HOST-RESOURCES MIB variables instead (which indicate the ACTUAL system reboot, rather simply the restart of the SNMP agent) hrSystemReboot.AlertDefinition /RjL

I'm going to note that, atleast for our SNOW contract, their event management subsystem was an extra-cost item that was a lot of $$$$ so we skipped it.

Define a group for each one of the services and then use the daily group availability to display a status icon in each square. Since we do not have group properties you may have to use a specific name pattern for your groups to select which ones get display in the status matrix. Controlling membership of the group will…

when developing these I start with a database query that returns the set of nodes that match the criteria: SELECT nodeid, traptype, oidvalue FROM traps a INNER JOIN trapvarbinds b ON a.trapid = b.trapid AND b.oidname = 'spSensorValue' WHERE a.acknowledged = 0 AND traptype = 'HHMSAGENT-MIB:spUnknownStatus.301' ORDER BY…

sounds like a good Idea to me.

No. it only looks at the MAC bridge tables and the ARP tables to find the information, neither of which (directly) tells you if it has been assigned using DHCP. the IPAM product might help with telling you if an ip address is DHCP or Static, but that doesn't really help you tell if the client actually used DHCP to obtain…

that is a bug in the Solarwinds database manager => open a case on it. if you try it in the SQlserver management studio it will work fine.

My replies below only deal with the NCM additional poller install on additional polling engines. 7.2 (and earlier) had the option of running without the NCM additional pollers. In that case you could configure NCM to only use the primary polling engine. This was normally okay, because NCM scales pretty linearly with the…

I have deleted my replies because they do not apply to the version of NCM (7.2) you are running.

Historically Solarwinds had a lot fewer alerts and they all checked the node status explicitly if the alert needed to be disabled when the node was unmanaged. The behavoir has not changed, it's just that 1. we've gained more out of the box alerts,e.g. environmental alerts, stack ring alerts, and the check of condiions on…

it's part of the nightly database cleanup -- there is a stored procedure [dbm_Pollers_DeleteOrphans] that cleans them up.

pre 10.7: a) enable SNMP polling generally on the nodes b) combination of: 1. write a program to add the missing pollers and/or interfaces 2. use the pollerchecker tool to add the missing pollers (C:\Program Files (x86)\SolarWinds\Orion\PollerCheckerTool.exe) 3. use the node discovery to add the missing interfaces/volumes…

as a tip: if you change the rule to be a custom SQL alert you get the syntax being used, which often exposes the translation... it would also be nice if there was a 'does not contain' choice which would make the rules somewhat shorter..

(1) custom SQL variable in the alert message ${SQL:SELECT CASE WHEN adminstatus=9 then 'Unmanaged' WHEN adminstatus=2 THEN 'Shutdown' when operstatus=2 and unpluggable=1 then 'unplugged' WHEN Operstatus=2 then 'down' when operstatus=1 then 'up' ELSE 'unknown' END FROM [dbo].[Interfaces] where interfaceid=${InterfaceID} }…

NO! it does not :-) :-) (just verified)