Data Retention Policy in Tegsoft

Tegsoft data retention policy clarifies what data should be stored or archived, where that should happen and for how long.

This article covers the configuration steps to customize how long data is retained in Tegsoft.

If you do not specify a data retention policy in your Tegsoft system, the database tables listed below are retained for the specified default duration.

ARCHIVE parameter count:13
ARCHIVE parameter [1]: TABLENAME:TBLCCCAMPCALLD 365 days
ARCHIVE parameter [2]: TABLENAME:TBLPBXTRANSFER 365 days
ARCHIVE parameter [3]: TABLENAME:TBLLOADS 90 days
ARCHIVE parameter [4]: TABLENAME:TBLLOGINS 365 days
ARCHIVE parameter [5]: TABLENAME:TBLAUTHLOG 365 days
ARCHIVE parameter [6]: TABLENAME:TBLPBXRECLOG 365 days
ARCHIVE parameter [7]: TABLENAME:TBLCCAGENTLOG 3650 days
ARCHIVE parameter [8]: TABLENAME:ARCCCAGENTLOG 3650 days
ARCHIVE parameter [9]: TABLENAME:TBLCCSDR 3650 days
ARCHIVE parameter [10]: TABLENAME:ARCCCSDR 3650 days
ARCHIVE parameter [11]: TABLENAME:TBLCCCDR 3650 days
ARCHIVE parameter [12]: TABLENAME:ARCCCCDR 3650 days
ARCHIVE parameter [13]: TABLENAME:TBLDMLLOG 30 days

➤ Sample Output:
 

If you want to customize these default data retention durations, please follow the steps below.

1. Create a JSON file containing the following parameters. 

In the JSON file, edit only the DURATION (in days) parameter according to how long you want the data to beretained in the system. Other parameters should not be changed and different tables should not be added or removed in this JSON file.

[
	{
		"TABLENAME": "TBLCCCAMPCALLD",
		"DATECOLUMNNAME": "MODDATE",
		"KEYCOLUMNNAME": "DIALID",
		"DURATION": 365
	},
	{
		"TABLENAME": "TBLPBXTRANSFER",
		"DATECOLUMNNAME": "MODDATE",
		"KEYCOLUMNNAME": "TRANSFERID",
		"DURATION": 365
	},
	{
		"TABLENAME": "TBLLOADS",
		"DATECOLUMNNAME": "MODDATE",
		"KEYCOLUMNNAME": "LOADID",
		"DURATION": 90
	},
	{
		"TABLENAME": "TBLLOGINS",
		"DATECOLUMNNAME": "LOGIN",
		"KEYCOLUMNNAME": "LOGINID",
		"DURATION": 365
	},
	{
		"TABLENAME": "TBLAUTHLOG",
		"DATECOLUMNNAME": "AUTHDATE",
		"KEYCOLUMNNAME": "LOGID",
		"DURATION": 365
	},
	{
		"TABLENAME": "TBLPBXRECLOG",
		"DATECOLUMNNAME": "LISTENDATE",
		"KEYCOLUMNNAME": "LOGID",
		"DURATION": 365
	},
	{
		"TABLENAME": "TBLCCAGENTLOG",
		"DATECOLUMNNAME": "BEGINDATE",
		"KEYCOLUMNNAME": "LOGID",
		"DURATION": 3650
	},
	{
		"TABLENAME": "ARCCCAGENTLOG",
		"DATECOLUMNNAME": "BEGINDATE",
		"KEYCOLUMNNAME": "LOGID",
		"DURATION": 3650
	},
	{
		"TABLENAME": "TBLCCSDR",
		"DATECOLUMNNAME": "EVENTDATE",
		"KEYCOLUMNNAME": "SDRID",
		"DURATION": 3650
	},
	{
		"TABLENAME": "ARCCCSDR",
		"DATECOLUMNNAME": "EVENTDATE",
		"KEYCOLUMNNAME": "SDRID",
		"DURATION": 3650
	},
	{
		"TABLENAME": "TBLCCCDR",
		"DATECOLUMNNAME": "CALLDATE",
		"KEYCOLUMNNAME": "CDRID",
		"DURATION": 3650
	},
	{
		"TABLENAME": "ARCCCCDR",
		"DATECOLUMNNAME": "CALLDATE",
		"KEYCOLUMNNAME": "CDRID",
		"DURATION": 3650
	},
	{
		"TABLENAME": "TBLDMLLOG",
		"DATECOLUMNNAME": "MODDATE",
		"KEYCOLUMNNAME": "LOGID",
		"DURATION": 30
	}
]

2.  To upload this JSON file to the Tegsoft system, follow the steps below.

Step 1 – Click the System Management.
Step 2 – Click the Custom Application.
Step 3 –Click the Custom Application tab.
Step 4 –Click plus icon (+) to upload Data Retention Policy (JSON file).

After uploading the JSON file to the Tegsoft system, your new data retention policy will take effect, and your data will be retained in the system based on this configuration.

➤ Sample Output: 
In this sample output, the retention duration for the first two table have been changed.

Tegsoft makes no representations or warranties, either express or implied, by or with respect to anything in this document, and shall not be liable for any implied warranties of merchantability or fitness for a particular purpose or for any indirect, special or consequential damages.

Copyright © 2023, Tegsoft. All rights reserved.

"Tegsoft" and Tegsoft’s products are trademarks of Tegsoft. References to other companies and their products use trademarks owned by the respective companies and are for reference purpose only.