VPN Tunnel History report shows the last 2 to 7 days of data

7/19/2019 7:31 AM

3/23/2022 11:04 PM

The report displays historical info for all Remote Access VPN Tunnels over the last 30 days

Webconsole > Report > Manage Report > Remote Access VPN Tunnel History - Last 30 Days

Network Performance Monitor

This issue occurs due to the default setting for RemoteAccess table is 2 or 7 days.

The default setting for NPM_Settings_ASA_RemoteAccess_RetainDownTunnels_Days is 2 days
The default setting for NPM_Settings_ASA_RemoteAccess_Retain_Days is 7 days

Steps To Resolve 

1. Remote to the SolarWinds server
2. Open the Database Manager
3. Click Add Orion Server
4. Find the SolarWinds database (i.e SolarWindsOrion)
5. From the left pane, select the Settings table
   • To filter only the RemoteAccess setting, run the following query below:

   • -- Scripts are not supported under any SolarWinds support program or service.
     -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
     -- disclaims all warranties including, without limitation, any implied warranties
     -- of merchantability or of fitness for a particular purpose. The risk arising
     -- out of the use or performance of the scripts and documentation stays with you.
     -- In no event shall SolarWinds or anyone else involved in the creation,
     -- production, or delivery of the scripts be liable for any damages whatsoever
     -- (including, without limitation, damages for loss of business profits, business
     -- interruption, loss of business information, or other pecuniary loss) arising
     -- out of the use of or inability to use the scripts or documentation.
     
     SELECT TOP 1000 * FROM [dbo].[Settings] where settingid like '%ASA%'

6. Find the setting NPM_Settings_ASA_RemoteAccess_Retain_Days
7. Select Enable table editing
8. Adjust the CurrentValue, which by default is 7-days, up to the maximum of 30 days.
9. After updating the value, click Enter button
10. Find the setting NPM_Settings_ASA_RemoteAccess_RetainDownTunnels_Days
    • This correlates to the disconnection of the sessions, if only retained for 2 days, even if you change the "Days of Data Retention", a report will most likely still only show the last 3 days
11. Adjust the CurrentValue, which by default is 2 days, up to the maximum of 365 days.
12. After updating the value, click Enter button