View and update Call Data Record (CDR) data retention in VNQM

10/22/2018 9:52 PM

6/8/2020 5:44 PM

We should be aware that different requirements for data retention applies for our customers using VNQM. Some customers need a longer CDR data retention. Below are information for CDR data retention in VNQM.

• This cannot be modified directly from the Orion Website.
• The default retention for CDRs is 30 days. 
• The default retention for CMRs is 2 days.

VoIP & Network Quality Manager

IMPORTANT REMINDER:

• Modification of the CDR Retention settings are not recommended by SolarWinds as anything greater than the default settings will increase the amount of database space required to store CDR/CMR related information.
• We recommend that you create a backup of your SolarWindsOrion Database before making any changes. 
• Increasing retention settings may cause the table to grow very large and will impact performance within the database. If you notice performance issues, you need to return retention back to its default settings.
• Changes can be made by using the SolarWinds Database Manager or SQL Server Management Studio

Using Database Manager:

1. On your Windows Server, search for Database Manager.
2. Click Add Default Server.
3. Right-click on your SolarWindsOrion Database.
4. Select New Query.
5. Use the following query to view the value for CdrDataRetentionDays:

   • Select * From [dbo].[VoipConfig]
     Where Name = 'CdrDataRetentionDays'

6. Use the following query to update the value for CdrDataRetentionDays:

   • -- 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.
     
     Update VoipConfig Set Value = '30' Where Name = 'CdrDataRetentionDays'

• NOTE: Change the value from 30 to your preferred value. For example,90

 

Using SQL Server Management Studio:

• 1. On your Windows Server, search for SQL Server Management Studio.
• 2. Log in to your SQL Server Management Studio.
• 3. Expand Databases.
• 4. Right-click on your SolarWindsOrion Database.
• 5. Select New Query.
• 6. Use the following query to view the value for CdrDataRetentionDays:

  • Select * From [dbo].[VoipConfig]
    Where Name = 'CdrDataRetentionDays'

• Use the following query to update the value for CdrDataRetentionDays:

  • -- 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.
    
    Update VoipConfig Set Value = '30' Where Name = 'CdrDataRetentionDays'

NOTE: Change the value from 30 to your preferred value. For example,90.

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.