Creating an auditing report

You can use Crystal Reports to create an auditing report. Additionally, you can use the database fields to create a Notification to help you track information.

  1. Create a Crystal report or notification using fields from the SNAUDIT table in the Smart Notification database.
    USERID
    The Infor BI for Lawson user that made the report request.
    TREEENTRYID
    This is the ID of the Smart Notification that the user requested.
    USERIP
    The is the machine IP address the request was initiated from.
    PARAMETERCOLLECTION
    This is the collection of parameters used in the notification.
    FILTERDEFINITION
    These are the filter rules used to generate the notification.
    READINFOSET
    Indicates whether the Infoset was regenerated for this request.
    READDATASOURCE
    Indicates whether the data source was read for this request.
    REQUESTTIME
    This is the date and time the request was initiated.
    PROCESSEDTIME
    This is the date and time the request was rendered to the user.
    ACCESSVALUE
    This field will store the user or group value that allowed the user to see this report. If this field is null then the request was denied access.
  2. Save the report or notification.