AE DB Revision Report

Revision reports can be created in each AE system to have detailed information about modified, imported, transported or deleted objects, objects that were modified at, task starts and abnormal ends, and accesses of any kind logged internally. The OBJECT_AUDIT key of the specific UC_CLIENT_SETTINGS variable serves to activate the logging procedure. To structure this data chronologically in a revision report, you can use the AE DB Revision Report (ucybdbrr) utility. For more information, see OBJECT_AUDIT.

Important!

• You cannot add or remove users from a user group when the logging for revision reports has been activated in the client. In this case, memberships can directly be specified in the User object.
• Version Management is automatically activated when the logging for the revision report is activated. It is required to compare objects and cannot be deactivated. For more information, see Version Management Page.
• You can also use the AE DB Reorg utility to reorganize revised data (object audits).

Create Revision Reports

Start the AE DB Revision Report utility from the command line and define the parameters you require, such as the period, or the areas that should to be monitored. Use the following syntax where the order of the parameters does not matter:

UCYBDBRR -B -Cclient [-Farea -Ooutput file-D1start time-D2end time-X -A-IINI file-Llanguage]

Example:

All start time and runtime modifications of client 3 which take place between 1 April 2017, 20:00 (08:00 pm) and 2 April 2017, 06:30 am are output to the file C:\revision\report01.txt.

UCYBDBRR -B -C0003 -FSTART,RUN_MOD -OC:\revision\report01.txt -D120170401200000 -D220170402063000

The parameters -B and -C are required, the rest is optional with default values being used for the non-specified parameters. For a list of all values including their descriptions, see Start Parameters - Utilities.

The utility AE DB Revision Report returns the following codes and messages, depending on the situation that has occurred:

• 0
  The utility has successfully ended processing.
• 1
  Message U0036139
  Error: Occurred when loading INI file settings.
• 2
  Message U0036138
  Error: Not possible to allocate memory for PCX.
• 3
  Message U0021004
  Cannot find INI file.
• 4
  Message U5005000
  No batch mode - please use parameter -B.
• 5
  Message U5005001
  No client has been defined!
• 6
  Message U0003301
  Could not allocate memory.
• 7
  Message U5005008
  Processing was canceled. The output file cannot be opened.
• 8
  Message U0036134
  Error: Cannot connect to AE source database.
• 9
  Message U5005005
  Processing was canceled. The date definition is either invalid or does not have the correct format (YYYYMMDDhhmmss).
• 10
  Message U5005012
  Processing was canceled. Versioning is in progress in client '&01'. Waiting for its end is not possible because the Automation Engine is not active.

Monitored Areas

The following areas are logged and you can store the relevant data in revision reports. Manual modifications as well as modifications made via script elements are logged except for the specific situations described in the section object modifications:

• Created and renamed objects
  Logs the details of objects that were created or renamed.
  

• Moved objects
  Logs the source and target folder of objects that were moved.

• Imported and transported objects
  Logs import and transportation times. Contents of the XML and transport files are not included in the revision report.
  

• Started and restarted tasks
  Logs the start time which is the activation time.

• Modifications at runtime
  Logs modifications at runtime which includes modifications that are made via monitors or concerning states, for example. In the case of JCL modifications, the JCL is not written to the revision report. You can see it in the object's report.

• Aborted tasks
  Logs tasks that show an abnormal end.

• Deleted or restored objects
  Logs the details of objects that were deleted or restored.

• Object modifications
  Logs changes of object definitions such as modified priorities or start types. It includes the old and the new values in that it shows the part of the object's XML structure that includes the modified.
  Not logged are:
  • Modifications that were made by using AE script
  • Status modifications of Sync objects
  • Contents of Variable objects,
  • Modifications of Calendar objects

• Accesses of any kind
  Logs accesses to objects and folders including successful accesses and access violations which occurred due to restricted AE authorizations.

Important! You must activate the entries SECURITY_AUDIT_FAILURE and SECURITY_AUDIT_SUCCESS in the UC_CLIENT_SETTINGS variable for this purpose. For more information, see SECURITY Parameters.

• User Logon/Logoff
  Logs the times at which users logged on to the system or off.