Application Logging

<< Click to Display Table of Contents >>

Navigation:  Tools >

Application Logging

It should be noted that InSights Into Data logs all SQL statements and File Imports.  

In terms of SQL statements run - it records all appropriate information - the database user, Windows user, query id, workstation name, the both the original and modified SQL Statement, as well as the date/time the query was run. .  

This will help provide an audit function of who accessed what data at what time. With sensitive data, this can be a very important feature.

 

The following screen shot shows the Logging results of various queries. You can see the list at the top - and the details on the bottom.

Tools_QueryLogging