JiriPsota ✭✭✭✭✭

You are using basic or advanced alert? Can you show as how exactly is your alert configured.

Last 7 days summarized by Date: SELECT Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate, Nodes.Caption AS NodeName, Interfaces.Caption AS Interface_Caption, AVG(Case OutBandwidth When 0 Then 0 Else (Out_Averagebps/OutBandwidth) * 100 End) AS AVERAGE_of_Xmit_Percent_Utilization, AVG(Case InBandwidth When…

Run following query. It inserts all nodes with Vendor like %Ruckus% into NodeSettings table. There is a watcher that checks this table periodically and will start background Wireless inventory for nodes that have proper row in this table. If you would like to start backgraound inventory immediately, restart Orion services.…

One of your SSIDs have single quotation mark in the name (St. Mary's School). Change the SSID so it will not contain ' and you will see all APs in NPM.

This should be known issue fixed in service release for NPM 10.4.

EW Capable means, device has proper IOSImage, devices with this IOSImage can support EW feature. But I have 40 EW Capable devices and only 2 of them support EW. To find out nodes that realy supports EW feature you should use these steps: 1. create new Universal Device poller * OID: 1.3.6.1.4.1.9.9.683.1.1.0 * Name:…

And make sure you have selected "Routing Neighbors" as "Type of Property to Monitor" in Advanced Alert Manager.

Hi, I was right. 'Transmit Bandwidth', 'Transmit % Utilization', 'Receive Traffic' and 'Receive % Utilization' are constant because you take them from CurrentTraffic Interfaces.OutBandwidth Interfaces.OutPercentUtil Interfaces.Inbps Interfaces.InPercentUtil In Interfaces table is the last poll. So for every DateTime for…

And here is an example how the alert can look like when you need two different interfaces in trigger condition (similar condition has to be used in Reset Condition). Jiri

Try this in the latest NPM 11.5 RC, where we have native support for F5 Virtual Servers, Pools and Nodes polling and also alerting.

We take into account the time when the Capacity Forecast was calculated e.g. ndays = DATEDIFF(day, <datetime when the Capacity Forecast was calculated>, CurrentDateTime) DaysToRichThreshold = Floor((Capacitythreshold - Aavg) / Bavg - ndays) The only one day difference in both calculations means you can get different number…

It works exactly how it was designed. There are only two options: 1. remove disappeared APs from database (disappeared from NPM point of view mean-the AP is not in results polled from controller) 2. don't remove disappeared APs There is no way how to remove the APs on UI. You can change the key in config file back to True…

It's because the sensor is not in polled results (may be some hardware change on device). The sensor is marked as deleted in APM_HardwareItem.IsDeleted column in database.

Do you have some rows in NPM_Routing and NPM_RoutingTable tables in database for specific NodeID?

This is known issue in NPM 10.5. You can try NPM 10.6 RC where the issue is fixed. If you are looking for the fix in your current version, you can download "Orion Core version 2013.1 - Hot Fix 1" from customer portal.

Device_Type is custom property on nodes and you want to set all interfaces on nodes with Device_Type='Access' to UnPlugged, right?

Run SQL to check hisorical data in database SELECT cp.UniqueName, cpa.AssignmentName, cps.* FROM CustomPollerStatistics cps JOIN CustomPollerAssignment cpa ON (cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID)JOIN CustomPollers cp ON (cp.PollerID=cpa.PollerID) WHERE cp.UniqueName like '%' -- custom poller name…

If your custom poller with different column as Label and also alert are well configured, so it should work. I've checked your case but diagnostics were not uploaded and also other files were sent to personal email so I have nothing in my hands. Anyway, this feature is widely used by our customers and as far as I know it…

Please open a support ticket and attach diagnostics and SNMPwalk from device. Thanks

Edit existing Advanced Alert "Alert me when an interface goes down". Try to use following macro in trigger action message ${SQL:SELECT Nodes.Caption FROM Nodes JOIN TopologyData ON (Nodes.NodeID=MappedNodeID) WHERE SourceInterfaceID=${InterfaceID}}

This make sense, please can you create a support ticket for new feature request. Thanks

You are right, after manually change the caption will be never auto-updated. Now it works as designed. If you would like to use different interface name construction create a ticket and mark it as new feature request or you can use Network Performance Monitor Feature Requests to see if other customers are looking for the…

To get the difference between two polls <sysClientsslStatTotNativeConns2> - <sysClientsslStatTotNativeConns1> select Counter as a MIB Value Type under Advanced Options when creating new custom poller for sysClientsslStatTotNativeConns. So you will have only one poller of Counter type for…

Try to use this in your Trigger Action Message: Node Name: ${SQL:SELECT NodeName=CASE (SELECT COUNT(*) FROM Nodes WHERE IP_Address='${NeighborIP}') WHEN 0 THEN '${NeighborIP}' ELSE (SELECT DISTINCT Caption FROM Nodes WHERE IP_Address='${NeighborIP}') END} Protocol: ${SQL:SELECT DisplayName FROM NPM_RoutingProtocol WHERE…

Yes, you should be able to create this kind of alerts in the latest NPM 11.5 RC.

Why? What is wrong after you have changed the poller type?

" but I was not able to get it into the report writer" - you mean, your new interface custom property is not available in Report Writer? I did a test and I was able to create a report with custom property used as filter in old Report Writer and also in new web based reporting. What is your support ticket number?

Create new SQL report and use this query SELECT SummaryMonth, NodeName, Interface_Name, AVERAGE_of_CircuitUtil_AvgRecvXmit FROM (SELECT ROW_NUMBER() OVER ( PARTITION BY SummaryMonth ORDER BY AVERAGE_of_CircuitUtil_AvgRecvXmit DESC ) AS 'RowNumber', SummaryMonth, NodeName, Interface_Name, AVERAGE_of_CircuitUtil_AvgRecvXmit…

Hi, with the following query you should get the results very similar to the table on web SELECT n.Caption , ModuleLabel.Label , SerialModuleSlotType.Status "SerialModuleSlotType" , Module.Status "Module" FROM Nodes n JOIN (SELECT cpa.NodeID , cpl.rowid , cpl.Label FROM CustomPollerLabels cpl JOIN CustomPollerAssignment cpa…

Settings and NodeSettings are tables in database. To change routing polling interval on all nodes run the query (replace <minutes> with your polling interval. The value can be from the range 1-10080): UPDATE Settings SET CurrentValue=<minutes> where SettingID='NPM_Settings_Routing_RouteTable_PollInterval' To change routing…