sunvad

below gives the total sessions from two devices. works for me in our environment. SELECT count ([data].[RemoteAccessSessions].[UserName]) AS [Number] FROM orion.asa.node AS data where [data].[RemoteAccessSessions].[SessionStatus] = 1 and ([data].[RemoteAccessSessions].[NodeId] = 123 or…

@"mesverrum" I get the following error. Am I missing something? TBREXH91 has 53 % average CPU load across 2 CPU's ` Critical Threshold: 90 % Top Monitored Process by CPU: MACRO SQL ERROR - No column name was specified for column 1 of 'nzhlmogo_4kg'. TBREXH92 has 52 % average CPU load across 2 CPU's ` Critical Threshold: 90…

Hi @"marlief22", quick question please. Does the custom poller stop polling for values if the node status is down? Service Status widget that I've created previously looks all wrong. Few nodes are down, however the status is displayed as "...is working". When I test the poller against the offline node, test result is a…

Hi, not very good at SWQL queries but I believe a sum function is required here. Have you tried below? We have two VPN gateways and this query gives me one result. SELECT count ([data].[RemoteAccessSessions].[UserName]) AS [Number] FROM orion.asa.node AS data where [data].[RemoteAccessSessions].[SessionStatus] = 1 and…

We have this issue too. Is yours fixed?

It worked! :) many thanks to you.

Haha, didn't notice the wrong tag! It won't populate your screen name somehow. But yes, will come back on the solution once I hear from Support. Thanks again.

Yes I think I should :) thank you!

Sorry for the long delay. Yes, CLI polling has been enabled and credentials test was successful. When I go to the advanced configuration screen, I do not see anything that matches with 2 min poll window. This is under ASA.

thanks Tony.

@"tony.johnson" Hi Tony, how is this done when a CASE function is used? Example, when below returns 'Down', is there a way to make the widget color Red? Select (Case When CurrentValue = 0 Then 'Down' Else 'Up' END) AS [Internet Status] From Orion.NPM.CustomPollerAssignmentOnInterface Where NodeID='127'

Bump!

Got it. Polling completion at 100% or 99% most of the time. Polling rate is at 63%. I have synched chart interval and poller interval times and that seems to have fixed the issue. Our client likes the perf chart more than the classic chart. All good now, thank you for your help, appreciate it. Cheers! 

Widget looks great now, thanks a lot. Here is the query: Select (Case When CurrentValue = 0 Then 'Down' Else 'Up' END) AS [Internet Status] From Orion.NPM.CustomPollerAssignmentOnInterface Where NodeID='435'

Thank you @"jaed", that definitely worked. However, I just realized traps are not received everyday, so it kind of defeats the purpose of the widget. I have assigned a custom poller to get IP SLA. Results are in milliseconds. When internet is down, it returns a current value as 0 or 0.0. SWQL query that you provided has…

Ah ok. I tried putting the case statement inside parenthesis but no luck. What should ideally go after END function based on the columns I've selected?

Thanks jd, will try this out but I'm wondering how does this query corelate to internet status on a WAN router?

Bump! :)

Hi, where can I check this info please?

Here's another example for active VPN users count: SELECT CurrentValue FROM Orion.NPM.CustomPollerAssignmentOnNode Where NodeID = 'X' AND DisplayName LIKE 'XXXXXXX' X = SolarWinds Node ID XXXXXXX = Name of the poller. It is usually something like crasNumSessions Hope this helps.

Hi @"Seashore" - Don't see any missing data in poll results in the UDP tool. Chart looks good since the sample interval has been changed. First thing I did when a gap appeared was to check other data and there was no missing information. Zero packet loss too. I'm going to monitor the VPN sessions chart for next couple of…

Update: Changed sample interval from 10 to 15 mins and the gap disappeared. Can see the data now so it has always been there somewhere in the DB. Strange this happened to only one node. Any thoughts as to what might have caused this and only on one device? :) Thanks.

It worked after I changed Up to numeric 1 and down to 2 CASE WHEN OperStatus = '1' THEN 1 ELSE 0 END AS IsUp, CASE WHEN OperStatus = '2' THEN 1 ELSE 0 END AS IsDown

How do you add connected and disconnected times for each unique MAC address? I assume these are the first and last update fields. I tried a new report from scratch and have issues with it. Please take a look at the following thread: thwack.solarwinds.com/.../wireless-clients-history-report

@"vispetto" Thank you. When I execute this I get the total ports correctly but used and available ports show as 0 for all results. Can you help pls?

Thanks @"daham_bm" and @"cscoengineer". How do you add connected and disconnected times for each unique MAC address? I assume these are the first and last update fields. I tried a new report from scratch and have issues with it. Please take a look at the following thread:…

Just done, thanks!

Thanks for your help Stuart. Here is the query from "Show SWQL" SELECT [data].[WirelessInterfaces].[WirelessClients].[DisplayName] AS [DisplayName],[data].[WirelessInterfaces].[DisplayName] AS [DisplayName1],[data].[DisplayName] AS [DisplayName2],[data].[Node].[DisplayName] AS…

Bump!

@"pavkal" I had a similar ask. did you manage to successfully create a report?