How do you change the the default look back days on Remote Access VPN Tunnel Report History in Reports from the default of 2 day to 30. Currently Running SQL 2018.For the record I'm a novice SQL user......Thanks
The OOTB Reports already show 30 days.
(As seen on the SolarWinds Orion public demo)
It shows states 30 days but in the SQL is only retaining 2 days on the report.Where in SQL would I find this to change it to thirty?
Are you only keeping 2 days of records?
What do you get if you run this query?
SELECT MIN([L2Stats].ObservationTimestamp) AS [OldestVpnRecord] , MAX([L2Stats].ObservationTimestamp) AS [NewestVpnRecord]FROM Orion.VPN.L2LTunnelStatistics AS [L2Stats]
If you don't have SWQL Studio installed, you can run it manually on YourOrionServer.Domain.Local/.../Swis.aspx
YourOrionServer.Domain.Local/.../Swis.aspx
I don't have any VPN in my lab, so I can't test the validity of this query, but it should work.
Cisco ASR Devices.pollerCisco ASR Devices
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches
