rshrewsbery ✭✭✭✭✭

Survey completed

We went with Arista about 2 years ago. I too would like to see better metrics for this vendor.

it has not worked for me since we moved to 2020.x.x

I am having this same issue

it appears it does not like the Union. I pasted just the top half of the script and it works fine. My goal is to get a 'sum' of each column at the top or bottom. 

This is exactly what I am looking for. Thanks so much for the help. 

We are using Cisco anyconnect. What I am trying to achieve is a KPI widget with all the VPN sessions with the sum of all ASA connections. We currently have the anyconnect spread across 5 different ASA's.

I will keep these in mind. Thanks for the response.

SELECT 1 as aa, [N].NodeCaption as [Device Name], COUNT(CASE WHEN [P].InterfaceName like 'mgmt%' THEN 1 ELSE NULL END) AS [MGT], COUNT(CASE WHEN [P].InterfaceName like 'Fa%' THEN 1 ELSE NULL END) AS [FastEthernet], COUNT(CASE WHEN [P].InterfaceName like 'Gi%' THEN 1 ELSE NULL END) AS [1 Gig], COUNT(CASE WHEN…

Forgive the ask, how do I get this into Solarwinds so I can test this?

I am having this same issue.