Live system usage and other tables

Edit online

Tables included

  • System Usage Event History
  • System Usage Event Type
  • System User Details

Data source objective

You can use this data source to:

  • Analyze the usage workflow for a user
  • Review the time a User has spent in OAS as a whole for each Event Type (Task)
  • Monitor System Usage over time.

Calculations in data source

  • Last Date
    Determines the date of the last occasion that the User accessed the system.
  • Time Difference
    Calculates the length of time, in seconds, between the user’s current login and their next most recent login.

Live Work queue History

Tables included

  • Issues History
  • Item (Material) History

Data source objective

This data source is specifically written for the purpose of reporting on Work queues. You can use this data to:

  • Analyse the outstanding review percentage of each work queueby priority
  • Review workqueues by set/group
  • Analyse workqueues that have been reviewed in the current month

Calculations in data source

  • Work queue Set Name
    Determines the label to be used for the Work queue being viewed or worked on by the user. If the category being used is “All Sets” then that will be the label applied to the Work queue. Otherwise, it will be the Display Name of the category.
  • Is Review This Month
    This is a flag set for Work queue records which had their most recent review on the day of, or after, the last PU. 1 = Record was last reviewed on the same day, or after, the last PU, 0 = Record was last reviewed before the most recent PU, include both (i.e. no filter) = All Work queue records.