CAM includes six default Analytics queries, which are available on the Existing Queries tab.
Documents based on version
Documents based on version
Parameters | Version |
Query Details | Returns a list of all the documents that have 10 or more versions create |
Empty Folders
Empty Folders
Query Details | Returns a list of all the empty folders in the workspaces in the configured external system |
Empty Workspaces
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
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
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
Documents count by Author
Query Details | Returns document count for each Author. |
Download Count by Users
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
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
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
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
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
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 |
---|
| Allows to count documents by the library and type. |