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)
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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.