Maintain the Database
Schedule database maintenance tasks to run at a regular frequency and start time, or perform the tasks manually for immediate results.
Configure automated database maintenance jobs
Configure the settings for when Content Security Reporter performs database maintenance jobs.
- Select Menu > Configuration > Report Server Settings.
- From the Setting Categories menu, select Database Maintenance.
- Click Edit, and configure these options:
- Schedule database maintenance — Create a schedule for when to run database maintenance jobs.
- Delete database records — Create database space by deleting database records.
- Index maintenance — Configure the frequency for when Content Security Reporter rebuilds indexes.
- Maintenance options — Specify the maximum number of records that are deleted at any one time.
Best Practice: Make sure that the database maintenance jobs occur at different times than the directory updates.
- Click Save.
Run manual database maintenance jobs
Delete database records by date range
Manually delete all database records within a specific date range.
CAUTION: Perform maintenance during off-peak times. Reports, queries, and dashboards are not available during maintenance.
- Select Menu > Configuration > Report Server Settings.
- From the Setting Categories menu, select Database Maintenance > Manual Maintenance.
- From the Manual database maintenance by date range section, select one of these options:
- Delete summary and detailed records.
- Delete summary records.
- Delete detailed records.
- Select the date range, then click Start.
- When the Confirm Maintenance message appears, click Yes.
- When the Maintenance Job Status message appears, click OK.
The database maintenance process is immediately queued.
Delete database records by log source
For a specific log source when the data is no longer needed.
CAUTION: Perform maintenance during off-peak times. Reports, queries, and dashboards are not available during maintenance.
1. Select Menu > Configuration > Report Server Settings.
2. From the Setting Categories menu, select Database Maintenance > Manual Maintenance.
3. From the Manual database maintenance by log source section, select a log source from the menu.
4. Click Start.
5. When the Confirm Maintenance message appears, click Yes.
6. When the Maintenance Job Status message appears, click OK.
The database maintenance process is immediately queued.
Repopulate columns
Repopulate custom and user-defined columns to apply settings to existing database records.
CAUTION: Perform maintenance during off-peak times. Reports, queries, and dashboards are not available during maintenance.
Substituting Specific IP Addresses example:
Assume you have created a user-defined column to substitute specific IP addresses with the custom string value test-lab and now
you have existing database records you want to apply to your created user-defined column.
Use the Repopulate Columns dialog box to repopulate the user-defined columns. By repopulating the columns, the specified IP
addresses in existing database records now appear with the custom string value test-lab.
In this scenario, you are able to:
- Identify which specific IP addresses to substitute.
- Apply the custom string value test-lab to existing database records.
- Update database records by repopulating columns.
- Select Menu > Configuration > Report Server Settings.
- From the Setting Categories menu, select Database Maintenance > Manual Maintenance.
- From the Custom and user-defined columns section, click Repopulate Columns.
- Configure the options for Custom columns and User-defined columns, then click OK.
- When the Confirm Maintenance message appears, click Yes.
- When the Maintenance Job Status message appears, click OK.
The re-populate columns process is immediately queued
Rebuild indexes
Perform manual index rebuilding when you want to rebuild the indexes immediately.
CAUTION: Perform maintenance during off-peak times. During maintenance, the database and new queries and reports are not
available.
- Select Menu > Configuration > Report Server Settings.
- From the Setting Categories menu, select Database Maintenance > Manual Maintenance.
- From the Index Maintenance section, click Rebuild Indexes.
- When the Confirm Maintenance message appears, click Yes.
- When the Maintenance Job Status message appears, click OK.
The database maintenance process is queued immediately.
Run database statistics
View database statistics without performing maintenance.
- Select Menu > Configuration > Report Server Settings.
- From the Setting Categories menu, select Database Maintenance > Manual Maintenance.
- Click Run Statistics.
- When the Confirm Maintenance message appears, click Yes.
- When the Maintenance Job Status message appears, click OK.
The database maintenance process is queued immediately.
Manage database maintenance jobs
View and manage completed database maintenance jobs.
- Select Menu > Configuration > Report Server Settings.
- From the Setting Categories menu, select Database Maintenance > Status.
- From the Actions menu, choose from these options:
- Cancel — Stop Content Security Reporter from processing the selected database maintenance jobs.
- Delete — Remove the selected database maintenance jobs from the Status list.
- Delete All Completed Jobs — Remove all completed database maintenance jobs from the Status list.
- Refresh — Update the Status list with current running database maintenance jobs.