1569

Topic:

This How-To article provides instructions on how to use SQL queries to search the History Log or Audit Log in the SecureDoc SQL Database.

Supported Product version:

• All SES versions

Environment:

• SQL express and full version of SQL 2008/2012

Steps to follow:

1. Please execute the search command for example: Where Description like '%sesadmin%'  on these two tables:
   (The sesadmin account is the admin account (application user account) that executed the commands within the SES Console)
   1. dbo.Event_Log
   2. dbo.Hist_Event_Log
2. Select the SES database > click on the + button on the “Tables” > right click on i.e. dbo.Event_Log and click on “Select Top 1000 Rows”.
   1. 
   2. 
3. At the bottom of the table, please enter the following command: Where Description like ‘%sesadmin%’

1. Highlight the whole line and then click on button Execute
2. Scroll to the lower pane to the right there will be a description and date of the execution.

1. The same command can be executed for the dbo.Hist_Event_Log