Configuring Patroller database options - Patroller 6.7

The Genetec Patroller™ database options are configured on the General page of Genetec Patroller™ Config Tool.

1. Open Genetec Patroller™ Config Tool.
2. Go to the General page.
3. Beside SQL server, select the address and name of the SQL server.
4. In the Database name field, you can leave the default database name, or change it if desired.

   You can change this name at any time to create a new database.

5. Beside Use Windows authentication, do one of the following:
   • Turn this setting on to use your Windows credentials to connect to the database.
   • Turn this setting off to use the specific User ID and Password you specified during Patroller installation to connect to the database.
6. In the User id field, enter the User ID to connect to the Patroller database. This User ID was entered during Patroller installation.
7. In the Password field, enter the password to connect to the Patroller database. This password was entered during Patroller installation.
8. Click Advanced to configure the following:

   Max logout

   Set the amount of time (in hours) that a user can be logged out and still resume their shift when logging back on. When this period has elapsed, or if a different user logs on, the system sees this as the start of a new shift and the data presented to the user reflects that. A value of 0 deactivates this feature, meaning that a new shift begins anytime a user logs in. The default logout time is 4 hours.

   Store reads for

   Set the amount of time that reads are stored in the Patroller database. Reads older than this value are deleted from the database at the start of the next shift. The default storage time is 96 hours.

   Store hits for

   Set the amount of time that hits are stored in the database. Hits older than this value are deleted from the database at the start of the next shift. The default storage time is 120 hours.

   Record search

   Set the amount of time that records (reads or hits) are searchable by the Patroller user. Records older than this value will no longer be searchable at the start of the next shift. The default search time is 48 hours.

   Record display

   Set the amount of time that a record can be displayed. The default time is 12 hours.

   Folder path

   Click browse or type the folder path where the system stores the ALPR images, context images, and wheel images associated with overtime enforcement. The default location is C:\Program Files (x86)\Genetec AutoVu 6.7 \Data.

   WARNING: License plate read images are now stored directly on the file system. Image files are not encrypted because SQL Server Express does not support FILESTREAM encryption. You can manage access to the image folder using NTFS or a device encryption solution such as BitLocker.

   IMPORTANT:

   • Ensure that the disk has enough free space to store the database and license plate read images according to the retention period.
   • Exclude the folder path from the antivirus scan running on the computer.
   • If you change the folder path, ensure that the new folder has read-write access authorization.

   Offload query timeout

   Define the timeout duration for the offload queries. The default timeout is 1800 seconds.

   Extra parameters

   The string to connect to the Patroller database.

   NOTE: You should not need to configure this option since SQL is installed automatically, or an existing SQL instance is used when you install Patroller.

9. Click Test connection, to test the connection to the Patroller database with the options selected.
10. Click Apply.