Billing statistics - users

This script is a billing script that reports on all users who had their Relativity access enabled, and belonged to a group which was assigned to a workspace during a specific month. The data is taken as a snap shot daily when the Case Statistics Manager runs. This script can be run at any time from Home.

Inputs

After clicking Run on the Script console, enter values for the following inputs:

Billing statistics users window

  • Usage Period Year (YYYY) is the year you wish to report on.
  • Usage Period Month (MM) is the month you wish to report on.
  • Replace User Name With Hash Value determines whether the username portions of user e-mail addresses are replaced by a hash value.
  • Hide Case Names determines whether the case names are hidden in the report.

Results

After you run the script, the Billing Statistics - Users report displays.

The report includes the following columns:

Column Definition
Case Name The name given to the workspace in Relativity.
Case Artifact ID The unique Artifact ID associated with the workspace specific to that environment.
Usage ID The usage ID given to the workspace. This is a unique workspace and month identifier which combines Instance, Case Artifact ID, Year, and Month.
Case User ID The unique identifier for that workspace, user, and month which combines Usage ID and User Artifact ID.
User Artifact ID The unique system-level Artifact ID associated with the user.
Relativity Case User Name The user's name as entered in the Relativity workspace.
Original Email Address The original e-mail address of the user if changed during the month.
Flag Indicates whether the user e-mail associated with that account, changed during the month.
Is System Admin Indicates whether the user is associated to the System Administrators group.
Logged In This Month If a user accesses the instance, a 1 appears in this column.
Last Login Date on which the user last logged into the system.
Last Login UTC The time the user last logged into relativity in UTC time.
Replace User Name With Hash Indicates whether the username portions of user e-mail addresses are replaced by a hash value.
Time Executed Date on which the report was generated.
Time Executed UTC The UTC time when the report was generated.

Retrieving historical data

When you upgrade to Relativity 9.7 or above, the roll-up script pulls information for the following columns from a table that is pre-populated with data from the month that you upgrade as well as the previous month:

  • Last Login UTC
  • Last Login
  • Logged In This Month

If you want to use this script to pull older historical data, contact our Support team for the Billing statistics – users script version 11, which supports this functionality. Additionally, verify that your Audit table contains the historical data that you need.