JiriPsota ✭✭✭✭✭

Are you able to get some values from ipRouteTable (1.3.6.1.2.1.4.21)? You can use UnDP or Toolset, if installed. If this works for you (you see the data), please open a support ticket and place the number here. Thanks, Jiri

UPDATE Interfaces SET UnPluggable=1 WHERE NodeID in (SELECT NodeId FROM Nodes WHERE Device_Type='Access')

As I wrote before: Use SQL Server Management Studio, create new database view. (use wizard or this query to create new view) CREATE VIEW [_test] AS SELECT Interfaces.NodeID, Interfaces.InterfaceID, Interfaces.Caption AS Interface_Caption, Interfaces.InterfaceType AS Interface_Type FROM Nodes INNER JOIN Interfaces ON…

Use SQL Server Management Studio, create new database view that will use your query. Right click your view in tree and select Edit Top 200 Rows.

Hi, create new Advanced SQL report and try to use following as SQL (instead of ifSpeed use your poller name in WHERE condition): SELECT Nodes.Caption AS NodeName , cp.UniqueName AS Poller_Name , cl.Label , cs.Status AS Status FROM Nodes INNER JOIN CustomPollerAssignment ca ON (Nodes.NodeID = ca.NodeID) INNER JOIN…

Try to use this SQL ${SQL:select cs.status from CustomPollers cp, CustomPollerAssignment ca, CustomPollerStatus cs where cp.UniqueName='upsBasicBatteryStatus' and cp.custompollerid=ca.custompollerid and ca.custompollerassignmentid=cs.custompollerassignmentid and ca.NodeID=7}

Basic scenario: you have custom poller that polls table with two rows and you know the RowIDs and the RowIDs never change, so in such case you can use Advanced SQL report. If you would like to have one report (I mean one select) for more nodes, all nodes have to have the same RowIDs in polled UnDP table. 1. create new…

I understand, anyway open a ticket and provide as much details as possible (can we get the collector logs?). We can then schedule a goto meeting and check what's going on if you will agree.

Can you try to run the SQL query (in SQL Management Studio or other tool). What is the result? Use specific Neighbor IP instead of ${NeighborIP} SELECT NodeName=CASE (SELECT COUNT(*) FROM Nodes WHERE IP_Address='${NeighborIP}') WHEN 0 THEN '${NeighborIP}' ELSE (SELECT DISTINCT Caption FROM Nodes WHERE…

If the polled value is a number and you want to see the value how it's polled, use None. Jiri

This could be known integration issue between NPM 10.4 and SAM 5.0. Please open support case, attach diagnostics and give me the ticket number. Thanks

Oh, now I see, your poller is not a table poller. According to selected alert type I've expected your poller is a table poller. If you poll only a single value (not a table), you have to change the alert type from "Custom Node Table Poller" to "Custom Node Poller". You have to change also the Trigger Condition, use Numeric…

What you see as Child Status are value from Nodes table (StatusDescription, GroupStatus,etc.). This values are updated when the interface is added/removed via UI or when status of some monitored interface on node is changed. That's the reason why unmanage/remanage has fixed the child status. To recompute child status run…

You are using Enumeration Format in UnDP, so the "Value" in Trigger condition has value "Up". Use "Numeric Value" instead of "Value" field and it should trigger. Trigger condition will look like: Numeric Value is greather than 1

During upgrade we do a background inventory to find out if there are some ASA nodes that supports new ASA pollers. If ASA pollers are discovered for some nodes, we assign new ASA view to their MachineTypes (ViewsByDeviceType) if they are set to “default”. It looks like there has to be some node with Unknown MachineType (at…

Can you check in the SNMPwalk whether sysObjectId is there and the data type is OID. SysObjectID is mandatory when you want to add a node as SNMP. Some devices report sysObjectID as STRING data type, but NPM expect OID, so this could be the second reason why you are not able to add a node as SNMP. Did you try to run the…

Did you try to use "Custom Node Table Poller" as Property to Monitor in Advanced Alert Manager. This type of alert can trigger for specific row in polled table.

SET @startPeriod=DATEADD(d,-30,getdate()) SET @endPeriod=getdate()

I am not sure what you are talking about. Your SQL report is using new Wireless tables that were introduced in NPM 10.5, so it couldn't have worked before upgrade in NPM 10.4.x. Anyway, does it mean the report doesn't work for you now in NPM 10.6?

Here is one more query, may be you will find it useful http://thwack.solarwinds.com/docs/DOC-171677

Your NPM version is too old, you should upgrade your NPM. There is no way how to trigger alert on specific row from polled table in your current version.

And what is the trigger condition?

When the polling interval is not set in UnDP, it means the default poll interval will be used. For this type of custom poller it's node statistical poll interval. It did not work before, because you had different polling interval on custom poller and transform poller. They have to be the same.

Hi, what's your NPM version? This is old bug that was already fixed (I am not sure now about the version). The workaround is to restart services. Jiri

You can try to change the value for RDNSTimeout, seems like 30 is not enough for some clients.

As I can see on your advanced alert screenshot you are using ANY (Trigger alert when ANY of the following apply). That means the alert is triggered for all custom pollers where the custom poller name is cE.... OR the rate is ..... Change the trigger condition, use ALL instead of ANY. Jiri

What's your NPM version? Can you check in your NPM database what InterfaceIndex have interfaces with Unknown status.

View Limitation works for me as expected (tested in NPM 10.6). I've tried Group of Nodes and Single Group limitation. What's your NPM version? Did you try to refresh the page after you Submit "Customize page"?

Can you try to reopen Report Writer and also Manage Reports page on web.

I need walks from CISCO-ENTITY-SENSOR-MIB and CISCO-ENVMON-MIB.