UserLock Documentation
UserLock Documentation
You are here: Reference > Console > Server administration > Database

Database

UserLock audits and saves in a database all user session activities on machines where the agent is deployed. The history of such activity can be used to exploit the reporting and analysis features offered by UserLock.

The option 'Store all events in database' is enabled by default after the installation of UserLock. Uncheck the corresponding box and click on 'Apply' in the 'Quick access' panel to disable the database events recording.

The installation package for UserLock includes a free 'Microsoft Access database' file (named 'UserLock.mdb') to facilitate its evaluation and handling. This database is configured as the default database to store all audited session events. This type of free database has a structural limitation on its maximum size (2 GB by design). That's why we suggest you to set up UserLock with a Microsoft SQL Express database (maximum size of 10 GB), SQL Server (no theoretical limit) or MySQL database when moving to your production environment to ensure greater history and performance capabilities.

How to configure a Microsoft SQL Express or Microsoft SQL Server database

UserLock supports the following database systems:

  • MS SQL Express 2005 and newer - 32/64 bit.
  • MS SQL Server 2005 and newer - 32/64 bit.

Please note that LocalDB editions are not supported.

An empty database must be created in the 'MS SQL Express/Server' database system. The Service Impersonation account defined in UserLock has to be granted permission to connect to the 'MS SQL Server' and to this database if you want to use the 'Windows authentication' mode.

Once done, you will have to:

  • Switch the radio button from 'Default database' to 'Other database'.
  • Launch the wizard by clicking on the button to the right of the connection string field.
  • Check 'SQL Server' in the 'Database connection' wizard and click 'OK'.

  • Type the name of the 'MS SQL server'.
  • Choose the authentication method to use.
  • Select the database previously created.

  • Test the database connection by clicking on 'Test'.
  • Validate the database change by clicking on 'OK'.

Read-only database connection string

A second connection string with fewer privileges can be defined to access the database in read-only mode. This connection string will be used when access to the database doesn't need modification rights as, for example, when generating reports, allowing you to limit write accesses to specific operations requiring this level of privilege.

You can configure this option by checking its corresponding box and then following the same procedure as described above.

Use Greenwich Mean Time

This option offers to save all session events audited by UserLock with GMT time instead of the local time.

Warning: This option is not retroactive. Once an event is recorded in the database with a specified time mode, switching back to the previous mode won't modify the time of events already stored in the database. Only new events will take into account the revised selected time mode.