...
Table 1.2 shows the relevant SQL column names and the value configured by default.
Table 1.1 - SQL Values
Action Description | SQL Value |
|---|---|
Delete | 0 |
Archive | Any positive number i.e. 1, 2, 3 etc. The number configured will be the number of days records will be archived |
Take No Action | NULL |
Table 1.2 - Column Names and Default Values
Column Name | Default Value |
|---|---|
ConnectivityLogDaysToKeep | 0 = Delete all records |
BookingSystemConnectivityLogDaysToKeep | 0 = Delete all records |
QubiActivityLogDaysToKeep | 1 = Archive for 1 day |
BookingDaysToKeep | NULL = Take no action |
ResourceMessagesDaysToKeep | NULL = Take no action |
EquipmentProblemsDaysToKeep | NULL = Take no action |
ConnectivityLogArchiveDaysToKeep | 0 = Delete all records |
BookingSystemConnectivityLogArchiveDaysToKeep | 0 = Delete all records |
QubiActivityLogArchiveDaysToKeep | 1 = Archive for 1 day |
BookingArchiveDaysToKeep | NULL = Take no action |
ResourceMessagesArchiveDaysToKeep | NULL = Take no action |
EquipmentProblemsArchiveDaysToKeep | NULL = Take no action |
...
| Code Block | ||
|---|---|---|
| ||
update dbo.ArchiveSetting set <column_name> = <value> where TenantId = 1 |
Example Queries
Archive Device Connectivity Log Records for 5 days
...