Log Enhancements

Entity Items Visualization

It is now possible to track which items of a given entity have been visualized by any user. The log reports the username, the timestamp and the list (tab separator) of the entity items plus the info-cube of layout and/or screen under investigation.

 

 

Since this log can be high resource consuming it is suggested to activate it on demand.

 

How to activate the Log Tracker :

·        Open (or create) the folder \\...Board\Database\db_name\Common

·        Create the file DbOptions.txt

·        Edit the file as following : Trace: entity_name

 

In the \\...Board\Database\db_name\Common Folder a Daily File DbTrace_yyyymmdd.log is created.

Since the Log file is in the Database Folder it is suggested to remove it regularly to avoid any impact on the Database Back-Up process (its size can become significant).

 

The Log is triggered under the following conditions:

·        The Entity “under” tracking must be in the Layout Axes (by row or column) or it must be in a Pager

·        All the active selected items are reported independently from Layout Filters or Hide Zero options

·        The Selector Object does not trigger the Tracker

·        If you need to track multiple Entities the DbOptions.txt file must edited like

Trace: entity_name_1

Trace: entity_name_2

Trace: entity_name_n

 

 

Drill Through

When the Entity Item Visualization Tracker is active (see above) in the same Log file is reported the drill through execution. The log reports the username, the timestamp and SQL statement that has been executed.

(drill through process)

 

(drill through log)

 

 

NOTES

The Drill Through execution is now also tracked in the SQL Log but without any information about the executor. The sample above is tracked as:

SELECT *

FROM Products

 where Products.ID_Product = 'P03'

Table:Products, Sampled Record:1, Elapsed:16 [ms]

DSN=odbc_name

 

 

 

Security Audit Trail

 

In the Folder \\...Board\Dataset\Log\User the following log files are available.

 

Login.log : it tracks user’s login attempts providing information on user, timestamp, client device and attempt outcome (succeeded, failed, wrong password etc.)

 

ProfilesCreated.log : it tracks the creation of any new Security Profile (System Tab – Security profile) reporting timestamp and executor information

 

ProfilesModified.log : it tracks the change of any existing Security Profile (System Tab – Security profile) reporting timestamp and executor information.

Attention! it doesn’t report what has been changed but only that these has been a Profile modification.

 

UsersCreated.log : it tracks the creation of any new User (System Tab –Users) reporting timestamp and executor information

 

UsersModified.log : it tracks the change of any existing User (System Tab – Users) reporting timestamp and executor information.

Attention! it doesn’t report what has been changed but only that these has been a User modification (e.g. attribution of a new Security Profile).