Viewing and Analyzing the Lenel Adapter Logs

Two logs are used to record the activity of the physical access control system adapter. You can analyze them to understand potential issues.

MySQL Logging Database

Use a MySQL client to connect to the MySQL logging database you set up when preparing to install the Lenel OnGuard adapter, as described in Integrating Lenel OnGuard with MicroStrategy Identity. Then execute SQL statements to retrieve information.

For example, if you want to extract error logs, execute the following statement:

SELECT * FROM lenel_log where level='Error';

To extract a certain URI call, execute a SQL statement such as this:

SELECT * FROM lenel_log where level='loglevel' and uri = 'uri';

In the call statement above, loglevel may be error, warning, communication, info, performance, or debug, and uri is the URI. For example, to find a log entry regarding a cache flush, use the following statement:

SELECT * FROM lenel_log where level='Communication' and uri = '/ServiceApp/UsherLenel.svc/flush_cache';

Windows Event Log

To find log entries, such as for exceptions or errors that cause the database logging operation to fail, use the Windows Event Viewer. Under Applications and Services, see the entries with the name of MicroStrategy Identity. Specifically, look for entries with a Source of MicroStrategy Identity Lenel Web Service.

For steps to use the Windows Event Viewer, see Microsoft's documentation.

Viewing and Analyzing the Lenel Adapter Logs

MySQL Logging Database

Windows Event Log

Related Topics