nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

VPN Report Edit dbase

grivera

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

Find more posts tagged with

Comments

KMSigma.SWI

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

I don't have any VPN in my lab, so I can't test the validity of this query, but it should work.

grivera

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?

KMSigma.SWI

The OOTB Reports already show 30 days.

(As seen on the SolarWinds Orion public demo)

Quick Links

Dynamic Interface Dashboard; HTML/JS
I wanted to share a new dashboard a co-worker ( @mblackburn ) came up with to help us better view groups of interfaces and various metrics for each. Using a single HTML widget, we are able to visually compare numerous different interfaces by populating each interface dataset onto its own graph. We are able to view…
PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices