Network Management
After upgrading to 2025.4 ASA Remote Access data shows a few days old
After upgrading to version 2025.4, ASA Remote Access data displayed in PerfStack and other widgets appears to be 2-3 days old, with no current data visible. The displayed data increments by one day each day but remains delayed.
First published date
Last published date
Overview
Following the upgrade to SolarWinds Network Performance Monitor (NPM) 2025.4, users may notice that ASA Remote Access data in PerfStack and related widgets is outdated by 2-3 days. The charts reflect historical data only and do not show real-time or recent activity.
Product section
Cause
In 2025.4, we migrated the ASA_Remote access data into the newer timeseries table in the database. However, the SWIS object Orion.ASA.RemoteAccessDetail, which is responsible for providing data to the Perfstack page and other widgets on the web console, is still pointing at the ASA_RemoteAccess_CS_Detail_hist table, which now only includes the last 5 days' worth of data based on retention, but NOT the current 2-3 days of data, which now exists in a separate table. As a result, the data visible on the website is always 2-3 days old.
This will also affect the data that the Alerts query when alerting on ASA data, which would cause delays in alerting.
Resolution
To resolve this, we need to manually update the Information Service schema file that handles this data and point it at the correct table, which contains all the data for ASA Remote Access.
THIS NEEDS TO BE DONE ON ALL POLLERS - Primary Poller, Additional Pollers, Additional Web Servers
1.) Navigate to C:\Program Files\SolarWinds\Orion\Schemas - This is the default installation path; if you've installed on a different drive or have an old system, this path might be different.
2.) Find the 'VPN.RemoteAccess.Schema.Local.xml' file and open it with an administrative Notepad or text editor of choice.
3.) Find the line that includes <storage name="dbo.ASA_RemoteAccess_Detail" type="table" provider="Orion" tableName="dbo.ASA_RemoteAccess_CS_Detail_hist">
Screenshot for reference:
4.) Change the section from, tableName="dbo.ASA_RemoteAccess_CS_Detail_hist" to tableName="dbo.ASA_RemoteAccess_CS_Detail"
Screenshot for reference:
5.) Save the file and restart the SolarWinds Information Service v3. Repeat these steps for all SolarWinds Platform Servers (MPE, APE, AWS).
NOTE: The Configuration Wizard will not overwrite this change.