# How to View Data From an Audit Trail Database

In Designer, to view data from your Audit Trail database, create a query on the AuditTrail table:

1. Right-click on AuditTrail table and select New Query.
2. Provide a meaningful name for the query.

3. In the Query Text field, enter your query, for example: SELECT * FROM [AuditTrail] order by Timestamp desc LIMIT 0, 20

   This query returns the newest 20 log items.

4. Click Accept. Your new query will appear in the Application Explorer, under the AuditTrail table in the Databases node.

To view data in a third-party application, create the following query:

    SELECT
    	Timestamp, Username,  Action ,  Message
    FROM
    	AuditTrail