How to export Statistica Enterprise Audit Log?
Article ID: KB0075601
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10.0 and higher |
Description
How to export Audit log from Statistica Enterprise for further analysis.?
Resolution
Resolution 1. Save Audit log from Statistica Enterprise Manager by clicking on "Export" button manually
Audit Trail Log table is displayed under "Log Viewer" in Enterprise Manager. Click on "Export" button from the top ribbon menu bar to manually save the Audit log file.
Resolution 2. Populate spreadsheet with Audit log information through queries on tables stored in Enterprise meta-database
The Audit log information is stored in CSLOG table in the Enterprise server database. Create a database connection to your Enterprise server database, and create a data configuration query to retrieve the CSLOG contents.
Notice that the UserID in CSLOG file is encrypted as numeric numbers, instead of User ID texts. A solution to transact the numeric User ID in CSLOG file to User name texts, is to make use of another table CSUSER in Enterprise meta database. CSUSER file contains the user name in texts. You can do a SQL join query based on "UserID" in CSLOG file to "UserID" in CSUSER file, to obtain the texts of User Names.
The default query equivalent of the Log Viewer view is :Select CSLOG.*,CSUSER.NAME AS USERNAME from CSLOG inner join CSUSER on CSLOG.USERID = CSUSER.USERID
In this way, the Audit Log can be retrieved from Enterprise database through an Enterprise Data Configuration, which could be used in workspaces or analysis configurations for further processing and reporting.
Audit Trail Log table is displayed under "Log Viewer" in Enterprise Manager. Click on "Export" button from the top ribbon menu bar to manually save the Audit log file.
Resolution 2. Populate spreadsheet with Audit log information through queries on tables stored in Enterprise meta-database
The Audit log information is stored in CSLOG table in the Enterprise server database. Create a database connection to your Enterprise server database, and create a data configuration query to retrieve the CSLOG contents.
Notice that the UserID in CSLOG file is encrypted as numeric numbers, instead of User ID texts. A solution to transact the numeric User ID in CSLOG file to User name texts, is to make use of another table CSUSER in Enterprise meta database. CSUSER file contains the user name in texts. You can do a SQL join query based on "UserID" in CSLOG file to "UserID" in CSUSER file, to obtain the texts of User Names.
The default query equivalent of the Log Viewer view is :Select CSLOG.*,CSUSER.NAME AS USERNAME from CSLOG inner join CSUSER on CSLOG.USERID = CSUSER.USERID
In this way, the Audit Log can be retrieved from Enterprise database through an Enterprise Data Configuration, which could be used in workspaces or analysis configurations for further processing and reporting.
Issue/Introduction
How to export Audit log from Statistica Enterprise ?
Feedback
Yes
No
Powered by
