Included Queries

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

- 1.1 Documents based on version
- 1.2 Empty Folders
- 1.3 Empty Workspaces
- 1.4 Client & Matter Number are not in sync with workspaces
- 1.5 Size more than 10 MB
- 1.6 Documents count by Author
- 1.7 Download Count by Users
- 1.8 Users list with their group membership count
- 1.9 Users who never logged into the system
- 1.10 All (User) Activities
- 1.11 Documents per month per user
- 1.12 Concatenate Values
2 Other Queries
- 2.1 Document Count

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.

Two new queries for parameters for userid and username are included.

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.

Included Queries

Documents based on version

Empty Folders

Empty Workspaces

Client & Matter Number are not in sync with workspaces

Size more than 10 MB

Documents count by Author

Download Count by Users

Users list with their group membership count

Users who never logged into the system

All (User) Activities

Documents per month per user

Concatenate Values

Other Queries

Document Count

Related content