Active Administrator 8.6 - User Guide

Setting purge and archive options

Setting purge and archive options

To select specific events to purge or archive, click Purge Options or Archive Options. By default, the database shrinks after the database is purged or archived and the list of event definitions is not filtered. You can choose to include or exclude selected event definitions.

You can access the purge and archive options from the Purge Now, Archive Now, New, or Edit options on the tool bar.

To set options for the event purge archive process

1	Click Purge Options or Archive Options depending on the type you selected.

2	By default, the database shrinks after purging or archiving. Clear the check box if you do not want the database to shrink.

3	You can filter the list of events by typing text in the

4	Filter box. Once you have selected events, you can choose to show All, Selected or Unselected. Active only if Include or Exclude the selected event definitions check boxes are selected.

IMPORTANT: Events selected in Purge Options are deleted first. If the same events are selected in Archive Options, those events are not archived because they were deleted in the purge.

 

Table 73. Event purge/archive options

Option	Description
Do not filter event definitions	By default, all events are purged or archived based on the selected date range.
Include the selected event definitions	Select to specify specific events to purge or archive based on the selected range. Events that are not selected are not purged or archived.
Exclude the selected event definitions	Select to specify specific events to exclude from the database purge or archive. Events that are not selected are purged or archived.

5	Select the events to include or exclude from the purge or archive process.

6

Click OK.

Scheduling an event log purge and archive

Scheduling an event log purge and archive

You can choose to purge only, archive only, or purge then archive. You can select different events to purge or archive. Purged events are deleted from the live database. Archived events are copied to the archive database and then deleted from the live database.

IMPORTANT: If you select Purge then Archive, the events selected in Purge Options are deleted first. If the same events are selected in Archive Options, those events are not archived because they were deleted during the purge, which occurred first.

To schedule an event log purge or archive

1	Select Auditing & Alerting | Archiving & Purging.

2	Click New.

3	By default, scheduling is enabled. You can create a schedule and then disable it until you need it.

4	Type a description of the schedule.

5	Select the type of purge and/or archive.

 

Table 74. Type of purge and/or archive

Option	Description
Purge Only	Select to delete event entries and alert history items permanently from the live database based on the selected purge options.
Archive Only	Select to copy event entries and alert history items from the live database to the active archive database, and then delete the event entries and alert history from the live database.
Purge then Archive	Select to permanently delete event entries and alert history items from the live database based on the selected purge options, copy the event entries and alert history items from the live database to the active archive database and then delete the event entries and alert history items from the live database.

6	By default, selected event entries and alert history items older than 60 days are deleted.

7	Set options for the process, such as choosing to shrink the database, and include or exclude specific events. See Setting purge and archive options.

8	To change the default schedule, click Update, set the schedule, and click OK.

9

Click OK.

Managing the history log

Managing the history log

You can refresh the event archive and purge history, export it, and/or clear it.

To export the history log

1	Select Auditing & Alerting | Archiving & Purging.

2	Click History in the top pane.

3	Select History | Export.

4	Select a destination for the .csv file.

5	Click Save.

To clear the history log

1	Select Auditing & Alerting | Archiving & Purging.

2	Click History in the top pane.

3	Select History | Clear History.

4	Click Yes.

Running database maintenance

Running database maintenance

Routinely run maintenance on the Active Administrator® database. Database Maintenance runs an SQL script that reorganizes and rebuilds indexes on the Active Administrator audit database. If an index is fragmented less than 30%, the process reorganizes the index; if an index is fragmented 30% or more, the process rebuilds the index.

To run database maintenance

1	Select Auditing & Alerting | Archiving & Purging.

2	Click DB Maintenance.

3	Click Run Now.

To schedule database maintenance

1	Select Auditing & Alerting | Archiving & Purging.

2	Click DB Maintenance.

3	By default, scheduling is enabled. To disable the schedule, clear the check box.

4	To change the schedule, click Update, set the occurrence of the database maintenance, and click OK.

5	Click Save.