/
Included Queries

Included Queries

CAM includes six default Analytics queries, which are available on the Existing Queries tab.

Documents based on version

Parameters

Version

Query Details

Returns a list of all the documents that have 10 or more versions create

Empty Folders

Query Details

Returns a list of all the empty folders in the workspaces in the configured external system

Empty Workspaces

Query Details

Returns a list of all the empty workspaces in the configured external system

Client & Matter Number are not in sync with workspaces

Query Details

Returns a list of all documents that have client matter numbers that are not the same as their parent's.

Size more than 10 MB

Parameter

importFilesize

Query Details

Returns a list of all the documents that exceed more than 10 MB in size

 

 

Other Queries

The following are other common queries we have seen used:

Document Count

File

Description

File

Description

 

Allows to count documents by the library and type.

Related content

Analytics Schema and Tables
Analytics Schema and Tables
Read with this
Release Notes CAM May 2024 (24.05.20)
Release Notes CAM May 2024 (24.05.20)
More like this
Analytics Bulk Jobs
Analytics Bulk Jobs
Read with this
SQL Analytics (Legacy 1.0)
SQL Analytics (Legacy 1.0)
More like this
Analytics FAQ
Analytics FAQ
Read with this
Remove user(s) from M365 groups
Remove user(s) from M365 groups
Read with this

Let's Connect📌

☎ +1 630.598.1100
☎ ‪+44 20 3880 1550‬
📧 support@litera.com
💻 https://www.litera.com/support/

📝 Support is available:
4 am - 8 pm US Eastern
(9 am - 1 am GMT/BST
7 pm - 11 am AET) on normal business days (excluding holidays)

© 2024 Litera