/
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

Documents count by Author

Query Details

Returns document count for each Author.

Download Count by Users

Returns a list of all the documents downloaded by a user in descending date order

Users list with their group membership count

Query Details

Returns a list of all the users and their group membership count in descending order

Users who never logged into the system

Query Details

Returns a list of the users who have never logged into iManage or NetDocuments, or have viewed or authored any documents.

All (User) Activities

Parameter

Client, User, Matter

Query Details

Returns a list of the active users (who log in every day or have the most activities listed in the audit history)

Documents per month per user

Parameter

Created by

Query Details

Returns a list and count of all documents created by the user each month

Concatenate Values

File

Description

 

This script will concatenate values and split values accordingly. Use this for building ACL strings or other string values of multiple columns from Analytics.

 

 

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

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