Network Management

Adjust VoIP and IPSLA Data retention in VNQM

This article will show where to adjust data retention for VoIP and IPSLA statistics

First published date

6/25/2019 2:40 PM

Last published date

10/24/2025 9:57 PM

Overview

Everyone is looking for how to adjust the data statistics retention for VoIP CMR/CDR and IPSLA Operations but cannot find it on the Orion console. These settings can only be changed in the database.

Product section

VoIP & Network Quality Manager

Resolution

  1. Connect to the SolarWinds Platform server.
  2. Open Database Manager from the SolarWinds Platform folder of the Start menu.
  3. Click Add Orion server, then expand the SQL server instance and SolarWinds database in bold.
  4. Navigate to the VoipConfig config table and double-click to open the query window on the right.
  5. Click Execute query to show the top 1000 rows.
  6. Click Enable table editing and look for the specific data statistics that you want to adjust (Right column contains the default value):
  7. Edit the values and press Enter, then click Execute query again to ensure the change is saved.

    NOTE: Daily value should always be bigger than Hourly value; the Hourly value should always be bigger than Detailed value. This is to avoid any issues with Database Maintenance.