Data Recorded in the Audit Database

Data Recorded in the Audit Database

Issue

Customer would like to build reports to view specific information logged by UW, that is not available from Analytics.  What additional information is logged in the Audit Database?


Solution

There is quite a bit more information recorded into the Audit Database than what is shown in Analytics.  This Audit Database Overview document explains what information is recorded in each table of the Audit Database.

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...

      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...

      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...

      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...

      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...

      • Related Articles

      • Restore Audit Services HSQL database to shipping state

        Prerequisite: Unified Workspace is still configured to use the shipping "demo" HSQL database for Audit Services. Issue: webNetwork service will not finish starting.  The /stoneware/config/webNetworkTrace.log startup log file shows UW is getting stuck ...

      • Move database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...

      • What do the ID numbers in the audit database represent ?

        Product ID# (from the Product table): 1000 - teamPages 1001 - webPages  (Teacher webPages) 1002 - Forums 1003 - Application 1004 - Kernel 1005 - Reports  (webReports) 1006 - Forms  (webForms) 1007 - webPass 1008 - AppSelector 1009 - LenovoID 1010 - ...

      • What does webNetwork send to the SQL server to purge logging data each night?

        Each night at midnight the loader sends a SQL command to the SQL server to purge old log information.  That command is as follows : DELETE FROM LogTable WHERE LogTime < 'some date'; 'some date' is formatted like this: yyyy-MM-dd HH:mm:ss If your ...

      • Potential issues with HSQL database during upgrades

        With the release if 6.3.1.x and higher the HSQL database was updated.  This upgrade requires us to check each of your HSQL database files in \stoneware\hsql and upgrade the format to a newer storage method. It does this by reading the data from each ...