Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > VoIP & Network Quality Manager (VNQM) > View and update Call Data Record (CDR) data retention

View and update Call Data Record (CDR) data retention

Updated May 8, 2017

Overview

This article provides steps to view and update the Call Data Record (CDR) data retention through the SolarWindsOrion Database.

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

Environment

  • VNQM 4.2 and later
  • SolarWinds Database Manager
  • SQL Server Management Studio

Steps

IMPORTANT REMINDER:

  • Modification of the CDR Retention settings are not recommended by SolarWinds as anything outside of the default settings can and will impact performance of CDR/CMR related information.
  • Create a backup of your SolarWindsOrion Database using the SQL Server Management Studio 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 any of the following: SolarWinds Database Manager or SQL Server Management Studio

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:

Update VoipConfig Set Value = '30' Where Name = 'CdrDataRetentionDays'

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

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'

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

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.

 

 

Last modified
14:47, 14 Jul 2017

Tags

Classifications

Public