View the User Activity Log for EDS, IWS, and the EJM Monitoring Tool

Owned by Nancy Cohn (Deactivated)
Last updated: Aug 09, 2024 by Pamela Totas (Deactivated)
4 min read

The system logs any user activity in Eagle Data Services (EDS or EBS), Integration & Workflow Studio (IWS), and the EJM Monitoring Tool (MT) user interface (UI) applications into the database and makes that activity available for future retrieval and analysis. For example, it logs user activity such as add, update, and delete to provide an audit trail for such activity.

The applications use the estar.log_user_activity stored procedure, which appends the information into the pace_masterdbo.user_activity_log and pace_masterdbo.user_activity_log_detail tables. The log is available as a core query in System Management Center.

Before You Begin

The following components are required to use the user activity log:

  • Eagle core product v17.2.18 or higher

  • EagleML December 2019 or higher

  • IWS v1.0.9.19, MT v1.0.9.13, EDS v2.0.9.12 or higher

Run the User Activity Log - EBS, IWS and MT Query

You can view the user activity log information by running a SQL query in PL SQL developer or in System Management Center's Queries workspace. The User Activity Log - EBS, ISW and MT query is available as a core query in System Management Center starting with the v17.2.20 release.

To run a system query for the user activity log:

  1. In System Management Center, in the left navigation, clickĀ DiagnosticsĀ >Ā Queries.
    You see a list of all the available system queries.

  2. Enter a keyword forĀ the Query Name in the filter text box, for example, enterĀ user activity log.
    You see a list of available system queries based on the keyword.

    Queries workspace - user activity log keywords

  3. Click theĀ User Activity Log - EBS, IWS and MT row, and then click Run.
    You see the Define Query Parameters dialog box.

  4. Enter the query parameters for the user activity that you want to view.
    For example, select the EBS, IWS, or MT application. You can also define a range for date and time, and you can specify a user name associated with the user activity you want to view.Ā 

    Define Query Parameters dialog box

  5. Click Continue.Ā 
    You see the Run Query Result page based on the parameters you entered. The output is sorted by activity date in descending order. An example follows.

View the User Activity Log When the Core Query is Unavailable

You can view the user activity log information for Core versions between v17.2.18 and v17.2.20 when the User Activity Log - EBS, IWS and MT query is not available.

To run a system query for the user activity log:

  1. In System Management Center, in the left navigation, clickĀ DiagnosticsĀ >Ā SQL Query.
    You see the SQL Query workspace.

  2. Use the following SQL statement to query the information.

    selectĀ 
    uadet.activity_date, uadet.activity_type, uadet.object_type, uadet.object_name, uadet.activity_details,
    ualog.app_id, ualog.instance, ualog.username, ualog.login_date, ualog.app_versionĀ 
    Ā Ā Ā Ā Ā Ā from pace_masterdbo.user_activity_log ualog
    Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā inner join pace_masterdbo.user_activity_log_detail uadet on ualog.instance = uadet.pinstance
    Ā Ā Ā Ā Ā Ā where (ualog.app_id = 'EBS')
    Ā Ā Ā Ā Ā Ā Ā Ā Ā and (uadet.activity_date > trunc(sysdate))
    Ā Ā Ā Ā Ā Ā Ā Ā Ā and (uadet.activity_date < sysdate)
    Ā Ā Ā Ā Ā Ā Ā Ā Ā and (ualog.username = 'eagleadmin')Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā 
    Ā Ā Ā Ā Ā Ā order by uadet.activity_date desc

  3. Click Run Query.Ā 
    You see the information that met your criteria in the Result pane.

View the User Activity Log in Open forms

The EDS tool shows the Activity history of Solutions and Data Objects in the Open dialogs. This starts withĀ release IWS_2020_12_15 (EDS v2.0.10.46).Ā 

To view the user activity log in Open forms:

  1. Open the IWS for EDS Interfaces (EDS Tool) and in the left navigation, click Open.Ā 
    You see the Open one of existing items page.Ā 

  2. Click Solution or EDS Data Object.Ā 
    You see a list of existing solutions or data objects, as appropriate.

  3. Click the solution or data object.
    You see information for the selected solution or data object in the right pane. If the right pane does not appear, right-click the selected solution or data object and click Details.

  4. In the right pane, expand History.
    You see the corresponding user activity log information.Ā By default, the system displays only "modifying" actions, such as Save and Publish.

  5. You can include other action types such as Open and Close by clicking Filter Items and selecting the corresponding check boxes.


    If the solution you selected is currently opened by another user, you see a warning symbol.

  6. If you point at the symbol, you can view the related text. See the following example.Ā 


    The warning is intended to prevent concurrent changes and potential overwriting of somebody else's work. It is your responsibility to coordinate the changes with that other person.
    If you do not intend to make and save any changes, you can ignore the warning.