IMPORTANT: DELETING ITEMS FROM THE AUDITTABLE OR OTHER DATABASE TABLES
MAY BREAK YOUR GN4 SYSTEM!

DO NOT DELETE ANYTHING WITHOUT CONSULTING TERA SUPPORT FIRST!

You may want to get rid of the old items in the AuditTable and AuditLoginTable

Queries to clear old logins and logouts

declare @DAYS int

set @DAYS = 90

delete from gn_AuditLoginTable where gn_Id in (select gn_ExtraInfo from gn_AuditTable where gn_Action=0 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS)

delete from gn_AuditTable where gn_Action=0 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS

delete from gn_AuditTable where gn_Action=1 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS

Enter the appropriate number of days (@DAYS) and run it.

You may want to execute it before on a test system to find out how long it will take. The first time it will delete many records and will take probably a lot of time, so it would be better to execute it out of production.

Queries to clear actions 0,1 or 13

declare @DAYS int

set @DAYS = 90

delete from gn_AuditLoginTable where gn_Id in (select gn_ExtraInfo from gn_AuditTable where gn_Action=0 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS)

delete from gn_AuditTable where gn_Action=0 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS

delete from gn_AuditTable where gn_Action=1 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS

delete from gn_AuditTable where gn_Action=13 and DATEDIFF(dd, gn_time, GETDATE())>@DAYS

Enter the appropriate number of days (@DAYS) and run it.

You may want to execute it before on a test system to find out how long it will take. The first time it will delete many records and will take probably a lot of time, so it would be better to execute it out of production.

Action codes

See also

Making AuditTable smaller