Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
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

VPN Report Edit dbase

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

The OOTB Reports already show 30 days.

(As seen on the SolarWinds Orion public demo)

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

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.