Billing statistics - case rollup

The Billing Statistics - Case Rollup script is a billing script that reports on peak billable data for all cases in a Relativity environment. The peak billable data is the highest value within the range of a single month. This script can be used in environments where the auto-emailed statistics feature isn't possible.

Note: You must run this script in Admin mode and not from within a workspace. Otherwise, you will receive a warning and the script won't complete.

Inputs

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

  • Usage Period Year (YYYY)- the year you wish to report on.
  • Usage Period Month (MM) - the month you wish to report on.
  • Replace Case Name With Artifact ID - determines whether the name of the case is replaced by the case artifact ID in the report results.
  • Replace Matter Name With Hash Value - obfuscate the matter names in billing metrics.
  • Replace Client Name With Hash Value - obfuscate the client names in billing metrics.

Results

After you run the script, the Billing Statistics – Case Rollup report is displayed for the specified month and year. In this table, the term peak refers to the highest value within the range of a single month.

The report includes the following columns (listed alphabetically):

Column Definition
Account The name designated as the account name.
Activity Status

Reflects whether a workspace was Active or Inactive in a specific month. This determination is based solely on a single document view within the workspace during that month. No other actions within the workspace (e.g., adding/deleting documents, user activity) affect its activity status.

Note: Data for the timeframe of June to August 2023 may be inaccurate due to a field being temporarily disabled.

Archive Status Indicates a status of Archived if an ARM workspace restore is in progress. Otherwise the status is Online.
AuditRecordCount The total number of audit records stored in Data Grid per workspace
AuditSize The total size of audits in GB for that workspace. If the workspace does not have the Audit application installed, this calculation will be blank
CA Image Documents Number of documents with images and without natives run through a Analytics Index or Structured Analytics Set for the first time during the reported month.
CA Native Documents Number of Native documents that were indexed with Content Analyst for first time, during the reported month.
CA Native Size Size in GB of all Native documents indexed with Content Analyst for first time, during the reported month.
Case Artifact ID Unique artifact ID associated with a workspace in the environment.
Case GUID The case Globally Unique Identifier (GUID) associated with the workspace to that environment.
Case ID Unique identifier for the workspace across all environments which combines Instance and workspace artifact ID.
CA Text Only Documents Number of documents without an image or native that were run through a Analytics Index or Structured Analytics Set for the first time during the reported month.
CA Total Documents Total number of all documents run through a Content Analyst Index for the first time, during the reported month.
Client Artifact ID Unique artifact ID of the client associated with the workspace. If the workspace is deleted, no value is reported.
Client Name The name of the client associated with the workspace. If the workspace is deleted, no value is reported.
Client Status The current status of the workspace. This value is automatically inserted by the system based on a setting in Workspace Details Advanced Settings.
CurrentBillableFileSize Current day's data for BillableFileSize in GB.
CurrentDataGridFileSize Current day's data for DataGridFileSize in GB.
CurrentDocumentCountTextOnly Current day's data for DocumentCountTextOnly.
CurrentFileCount Current day's data for FileCount.
CurrentFileSize Current day's data for FileSize in GB.
CurrentImageFileSize Current day's data for ImageFileSize in GB.
CurrentNativeFileSize Current day's data for NativeFileSize in GB.
CurrentProductionFileSize Current day's data for ProductionFileSize in GB.
Data Generated UTC The time when the Billing Agent ran to generate the metrics used by the Case Statistics report.
Data Grid File Size The sum of all files in GB that are stored in Data Grid per workspace.
Document Count The peak total document count in the workspace.
Document Count Text Only The number of documents that do not have any images, natives, or productions per workspace. This value is calculated as the number of documents that are in the document table but not the file table, aggregated per workspace, and reported as the maximum found for the month (similarly to the Document Count column).
DtSearch Index Size Column currently not used.
ECA Application Installed True/False value indicates if the ECA application is installed to a workspace.
File Count The peak count of the total number of files in the workspace.
File Size

The peak total file size of files in the workspace in GB. This value only counts items in the file table and doesn't include container files in the repository. Therefore, not everything in the file repository is necessarily included in this value. For example, the file size total doesn't take into account working files/copies generated by a processing job. This value also doesn't count the SQL database.

Image File Size The peak size in GB of images files in the workspace that haven't been imported using Integration Points with file pointers. This value is taken from the peak of Total Billable File Size field.
Instance The name designated as the instance name.
LDF Size The peak database log data file (LDF) size of the workspace in GB.
Matter Artifact ID Unique artifact ID of the matter (through client) associated with the workspace. If the workspace is deleted, no value is reported.
Matter Name The name of the matter associated with the workspace. If the workspace is deleted, no value is reported.
MDF Size

The peak database primary data file (MDF) size of the workspace in GB.

Note: If your MDF is split into multiple NDFs, the sum of all NDF sizes is returned.

Name The instance name and the workspace name; if the workspace name is obfuscated, it is replaced by the workspace identifier.
Native File Size The peak size in GB of native files in the workspace that haven't been imported using Integration Points with file pointers. This value is taken from the peak of Total Billable File Size field.
Peak Status The peak status of any workspace in the environment. If any workspace was active during the reported month, the status is Active; otherwise, it is Inactive.
Prior CA Image Documents Number of documents with images and without natives run through a Analytics Index or Structured Analytics Set for the first time during the prior month.
Prior CA Native Documents Number of Native documents that were indexed with Content Analyst for first time, during the prior month.
Prior CA Native Size GB Size of all Native documents indexed with Content Analyst for first time, during the prior month.
Prior CA Text Only Documents Number of documents without an image or native that were run through a Analytics Index or Structured Analytics Set for the first time during the prior month.
Prior CA Total Documents Total number of all documents run through a Content Analyst Index for the first time, during the prior month.
Prior CA Year Month The prior month for the Analytics data. For example if the report is running in October, the metrics are from September.
Production File Size The peak size in GB of production files in the workspace that haven't been imported using Integration Points with file pointers. This value is taken from the peak of Total Billable File Size field.
Relativity Case Name The name given to the workspace in Relativity.
Relativity Integration Point Pushed Documents True/False value indicates if documents were pushed from a workspace using Integration Points.
SQL FT Size The peak size of the disk space that is allocated to the index (the file group) in GB. This will be within 5-10% of the actual size of the index. To estimate the actual size of the Full Text index, reduce the value reported by 5-10%.
Status Column currently not used.
Time Executed Date on which the report was generated.
Time Executed UTC The UTC time when the report is generated.
Total Billable File Size

The peak billable size in GB of all files in the workspace (this does not include files that have been imported using Integration Points with file pointers).

Total Billable File Size and the size of SQL database files are not directly related. Total Billable File Size is reporting on the size of natives, images, productions in the file repository. No SQL database files are included in this calculation.

Usage ID The usage ID given to the workspace. This is a unique identifier which combines instance, workspace artifact ID, year, and month.
Year & Month The year and month of the reported data.