GE V6 User Manual download pdf (Page 133)

Secure Perfect 6.1.1 User Manual 131

Database Tab - Reports

Alarm History, Badge History, Zone History, DI History, Time and Attendance, or Operator History

Reports

Use this tab to select the history database to use for this report. The file name displayed on the tab is the

currently selected archive database.

• Select archive database: Click to select the archive history database.

• Use default: Click to use the current history database.

Database Utilites

The Integrity utility runs automatically, following a database creation or conversion and upgrade from a

previous version of Secure Perfect. No user interaction is required.

The utility can be run manually if you want to check your database integrity. The system compares and

validates the integrity of your database schema. If selected, the system will automatically correct missing

or incorrect schema properties such as columns, keys, constraints, indexes, triggers, and tables. The

executable file is installed with Secure Perfect and resides in the Secure Perfect program folder.

1. Locate and double-click the DatabaseIntegrity.exe file to manually run the utility.

2. Enter the Server Name or click the browse button and navigate to the appropriate Server Name.

3. Enter the SQL system administrator ‘sa’ Database Password or accept the encrypted database

password of the default Server.

4. Click Connect to locate and connect to the Secure Perfect databases. The remaining selections are

now enabled. Accept the default options or review and disable selections.

5. Select one of two options:

 Verify that Check Database Integrity is selected.

OPTIONAL: Select the Autocorrect checkbox. This feature runs only once and

corrects obvious schema in the database. Results display in a report.

Autocorrect is not available on a Global Edition system.

Select which databases to check.

Select Start to begin. Wait as the Database Integrity tool compares and validates the

integrity of your database. Messages generate to an IntegrityCheck.html file in

your Secure Perfect application Logs folder.

 OR

Select Unlock Database Mutex to unlock the shared resource. Select Unlock to

unlock the database mutex for SPSQL.

6. Click OK when the Application Success window displays.

1 2 ... 128 129 130 131 132 133 134 135 136 137 138 ... 268 269

No comments

GE V6 User Manual Page 133