Billing statistics - users

For a faster and more modern method of gathering information across your instance, we recommend creating custom reports via Usage Reports within the Management Console instead of using Relativity scripts. See Usage Reports for more information.

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 Billing Agent runs. This script can be run at any time from Home.

Billing Statistics - Case Rollup stores data for 13 months by default to ensure high performance. If you would like to store this data for a longer period of time, edit the BillingDataRetentionPeriodInMonths instance setting from its minimum value of 13 months to your desired value.

Inputs

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

  • Usage Period Year (YYYY)—the year you wish to report on.
  • Usage Period Month (MM)—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:

ColumnDefinition
Case NameThe name given to the workspace in Relativity.
Case Artifact IDThe unique Artifact ID associated with the workspace specific to that environment.
Usage IDThe 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 IDThe unique identifier for that workspace, user, and month which combines Usage ID and User Artifact ID.
User Artifact IDThe unique system-level Artifact ID associated with the user.
Relativity Case User NameThe user's name as entered in the Relativity workspace.
Original Email AddressThe original e-mail address of the user if changed during the month.
FlagIndicates whether the user e-mail associated with that account, changed during the month.
Is System AdminIndicates whether the user is associated to the System Administrators group.
Logged In This MonthIf a user accesses the instance, a 1 appears in this column.
Last LoginDate on which the user last logged into the system.
Last Login UTCThe time the user last logged into relativity in UTC time.
Replace User Name With HashIndicates whether the username portions of user e-mail addresses are replaced by a hash value.
Time ExecutedDate on which the report was generated.
Time Executed UTCThe UTC time when the report was generated.

Client Domain Name

The name of the client domain associated with the workspace.

Client Domain Artifact ID

The unique Artifact ID associated with a client domain.

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.