Note: To help optimize performance, we will no longer store all historical data in Case Statistics tables. Starting on Feb. 8, 2022, Billing Statistics - Case Rollup will only store 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 to your desired value. Note the minimum value is 13 months. If no action is taken before Feb. 8, 2022, we will automatically set your instance to the 13-month default and all data from prior to that window will be removed from Relativity.
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.
After clicking Run on the Script console, enter values for the following inputs:
- 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.
After you run the script, the Billing Statistics - Users report displays.
The report includes the following columns:
|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.|
Client Domain Name
|The name of the client domain associated with the workspace. Relativity populates this value only when you enable client domains for a client. If you remove the associated user from Relativity, this column displays the word Deleted.
Client Domain Artifact ID
|The unique Artifact ID associated with a client domain. Relativity populates this value only when you enable client domains for a client. If you remove the associated user from Relativity, this column displays the word Deleted.
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.