Included Queries
CAM includes six default Analytics queries, which are available on the Existing Queries tab.
| Table of Contents |
|---|
| minLevel | 1 |
|---|
| maxLevel | 6 |
|---|
| outline | false |
|---|
| type | list |
|---|
| separator | brackets |
|---|
| printable | true |
|---|
|
| Expand |
|---|
| title | Documents based on version |
|---|
|
Documents based on versionParameters | Version | Query Details | Returns a list of all the documents that have 10 or more versions create |
|
| Expand |
|---|
|
Empty FoldersQuery Details | Returns a list of all the empty folders in the workspaces in the configured external system |
|
| Expand |
|---|
|
Empty WorkspacesQuery Details | Returns a list of all the empty workspaces in the configured external system |
|
| Expand |
|---|
| title | Client & Matter Number are not in sync with workspaces |
|---|
|
Client & Matter Number are not in sync with workspacesQuery Details | Returns a list of all documents that have client matter numbers that are not the same as their parent's. |
|
| Expand |
|---|
| title | Size more than 10 MB |
|---|
|
Size more than 10 MBParameter | importFilesize | Query Details | Returns a list of all the documents that exceed more than 10 MB in size |
|
| Expand |
|---|
| title | Documents count by Author |
|---|
|
Documents count by Author a list all the documents where the client & matter numbers are different than their workspacedocument count for each Author. |
|
| Expand |
|---|
| title | Download Count by Users |
|---|
|
ParameteractionCodeIdQuery DetailsDownload Count by UsersReturns a list of all the documents downloaded by a user in descending date order |
| Expand |
|---|
| title | Users list with their group membership count |
|---|
|
Users list with their group membership countQuery Details | Returns a list of all the users and their group membership count in descending order |
|
| Expand |
|---|
| title | Users who never logged into the system |
|---|
|
Users who never logged into the systemQuery Details | Returns a list of the users who have never logged into iManage or NetDocuments, or have viewed or authored any documents. |
|
| Expand |
|---|
| title | All (User) Activities |
|---|
|
All (User) ActivitiesParameter | 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) |
|
| Expand |
|---|
| title | Documents per month per user |
|---|
|
Documents per month per userParameter | Created by | Query Details | Returns a list and count of all documents created by the user each month |
|
| Expand |
|---|
|
Concatenate ValuesFile | 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 |
|---|
| View file |
|---|
| name | DocumentCountByLibraryType.sql |
|---|
|
| Allows to count documents by the library and type. |