Lesson 2: K2BAudit Analyzer

Using the application generated by Analyzer Knowlege Base you can take a look at what have changed in your data, who made those changes and when.

The Audit Analyzer Knowledge Base is the one that stores audit records and provides mechanisms to analyze them. It is used to identify when and/or who changed the audited data.

We already created this knowledge base before.

  1. Open the Bookmark of the Analyzer Application created before or Go to Analyzer Knowledge Base (K2BAudit> Open Audit Analyzer Knowledge Base) and run the Developer Menu in case you did't create the bookmark.
    OpenAnalyzeKnowledgeBase
    Open Analyzer Knowledge Base

  2. Click on K2BAuditAnalyzer.UI.Home Web Panel.
    AnalyzerHome
    Analyzer Home

  3. Once inside Analyzer Application Home, it's time to convert the audit log into audit record. For this, click on "Convert" located inside "Convert Logs".
    K2BAuditConvertLogs
    Convert Logs

    • Inside ConvertAuditLog Web Panel, it will show you how many logs are pending conversion and how many have been converted.
      • Click on "Convert" button. Once you do it, the button will change it's name to "Update Conversion Status". Click on "Update Conversion Status" too.
        K2BConvertLogsUpdateConversion
        Converting Logs

  4. Now that the logs are converted, go back to Analyzer Home Page. It's time to analyze the logs. For this, click on "Analyze" located inside "Audit Entries".
    K2BAuditAnalyze
    Analyze

    • Once inside there, a list of the operations done in your database should appear. Click on the following icon of each record to see the details:
      K2BAuditOperationsDetail
      Operations Detail

  5. Now we are going to use another view of analysis that lets you search by application data. In this case, we want to know which user and when modified the product Leica Elmarit - Tl. For this:
    • Go back to Analyzer Application Home Page and click on "Configure Application Data".
      K2BAuditConfigureApplicationData
      Configure Application Data

    • Change the filter from table "Client" to table "Product".
      K2BAuditFilterChanging
      Table Product

    • Select "ProductDescription" and add it. Click on "Save".
      K2BAuditAddingProductDescription
      Adding Product Description

Note: It is possible that you are not able to change the filter from one table to other. If this happens, you have to open your AnalyzerKB and inside "ConfigureApplicationData" Web Panel change the property "Allow Drag and Drop" from the grid to "False".

K2BAuditAllowDragAndDrop
Allow Drag and Drop

6. Go back to the Home Page and click on "Analyze" located inside "Analyze By Application Data" section.

K2BAuditAnalyzeByAppData
Analyze By Application Data

  • Select "Product" entity and click on "View Audit Records".
    K2BAuditViewAuditRecords
    View Audit Records

  • Open the filters and search by "Product Description" Leica. You can now see all the updates that were done to that product.
    K2BAuditProductDesc
    Product Description Filter