Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Included Queries

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

Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
separatorbrackets
printabletrue
Expand
titleDocuments 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

Expand
titleEmpty Folders

Empty Folders

Query Details

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

Expand
titleEmpty Workspaces

Empty Workspaces

Query Details

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

Expand
titleClient & 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.

Expand
titleSize 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

Expand
titleDocuments count by Author

Documents count by Author

Query Details

Returns

a list all the documents where the client & matter numbers are different than their workspace

document count for each Author.

Expand
titleDownload Count by Users
ParameteractionCodeIdQuery Details

Download Count by Users

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

Expand
titleUsers 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

Expand
titleUsers 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.

Expand
titleAll (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)

Expand
titleDocuments 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

Expand
titleConcatenate Values

Concatenate Values

File

Description

View file
nameSpilt string.txt

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
nameDocumentCountByLibraryType.sql

Allows to count documents by the library and type.