Creating Audit Actions Report

[makkawi]

This page describes how to create an Audit report based on incorta objects, Actions(Create, Update and Delete), And Users Who modify/create these objects.

Steps

1-As prerequisite for this report, incorta metadata schema has to be already deployed.

2-Make sure that Incortametadata schema has "ContentLookup" table created and loaded based on this file: ContentLookup.csv which is available in the attachments.

3-Create the following formula column in ACTION table to be used in the report:

Name: Object_Name

Label: Object Name

Type: Dimension

Formula: 

case(
    _IncortaMetadata.ACTION.ENTITYTYPE = 0, 
    lookup(
        _IncortaMetadata.USER.LOGINNAME, 
        _IncortaMetadata.USER.ID, 
        _IncortaMetadata.ACTION.ENTITYID
    ), 
    _IncortaMetadata.ACTION.ENTITYTYPE = 3, 
    lookup(
        _IncortaMetadata.FOLDER.NAME, 
        _IncortaMetadata.FOLDER.ID, 
        _IncortaMetadata.ACTION.ENTITYID
    ), 
    _IncortaMetadata.ACTION.ENTITYTYPE = 4, 
    lookup(
        _IncortaMetadata.DASHBOARD.NAME, 
        _IncortaMetadata.DASHBOARD.ID, 
        _IncortaMetadata.ACTION.ENTITYID
    ), 
    _IncortaMetadata.ACTION.ENTITYTYPE = 5, 
    lookup(
        _IncortaMetadata.SCHEMA.NAME, 
        _IncortaMetadata.SCHEMA.ID, 
        _IncortaMetadata.ACTION.ENTITYID
    ), 
    ''
)

4- Create the following internal session variable in the schema page:

Name:  ISV_Tenant_ID

variable:

queryDistinct(
_IncortaMetadata.USER.TENANTID, 
lower(
_IncortaMetadata.USER.LOGINNAME
) = lower(
$user
)
)

5- Import dashboard_demo_Audit_Action.zip dashboard into incorta dashboards.

Note: the dashboard, schema formula, and session variables are built using the incorta metadata schema based on its current name "_IncortaMetadata" , if the schema has a different name, it will have to be modified to match the current installed metadata schema name.