A chart that displays the total database size, file size and total size of workspaces for a given client artifact ID. This chart can automatically adapt to the Relativity client artifact ID for the user viewing the chart by using the #LoggedInUserClientID# token.
This script will iterate through each workspace associated with the client ID of the user who is currently logged into Relativity and get the total size, database size and file size for that workspace. If there are no documents for that workspace it will return 0 for all values.
This script can be modified to return the data for a specific Client ID be replacing the #LoggedInUserClientID# token with a specific client artifact ID.
The following example shows a table with workspaces of varying size including ones with no documents. Advanced users can change the returned sizes to MB or the number of decimals included by modifying the attached script.
This SQL script is compatible with the following chart types:
- Bar Chart
- Table Chart
Where to Use
This script should only be used in the admin level Broadcast tab.
How to Use
This chart is usable out of the box. Save the attached script and copy and paste it into either a bar or table chart in the admin level Broadcast tab.
Relativity Versions Tested On
- 9.2.X - 9.2.363.2
- 9.3.X - 9.3.452.1
Current Broadcast customers: Contact email@example.com to schedule your upgrade now.
If you'd like to learn more about our other Relativity applications, visit our Products page. Looking for a custom Relativity solution? We can help with that! Visit our Relativity Services page to learn how.