Page Comparison

...

Expand

title	External System Authentication

External System Authentication Table

Use the table name external_system_auth in your query.

Column	Description
id	The internal CAM id of each external system authentication row.
systemUniqueId	The external system unique id. Each tenant or instance will have a separate id. They look like: 91b692a0-c09d-00e8-9e62-0dfac7e82c00:~imanage:~Worksite2022
system	Type of the external system role. E.g. iManage, HighQ, Office365 etc
camrepoName	Name of the CAM instance that connects to this external system. E.g. Worksite2022
healthy	Marks if the system has errored recently. If it has, it is unhealthy (0). Healthy is =1
errorMessage	If an error occurred with the system, the last error displays here. For example, Unable to authenticate with HighQ server. Attempts(10) Consumed. Please contact system administrator.(Root Cause : 403 Forbidden)

Expand

title	External System Role

Use the table name external_system_role in your query.

Column	Description
id	The internal CAM id of each external system role.
ext_id	The external system id from the external system table.
name	Name of the external system role. E.g. Read, Read/Write, VESA etc
code	Code of the role. E.g. read_write, VESA, member etc
is_deleted	Marks if the role is deleted from CAM. 0 is not deleted. 1 is deleted.
created_user_id	The user id who created the external system role.
last_modified_user_id	The user id who last modified the external system role.
created_date	The date created
last_modified_date	The date last modified.

Expand

title	External System Role

Use the table name external_system_role_mapping in your query.

Column	Description
id	The internal CAM id of each external system role mapping.
security_role_id	Id of the security role that is to be mapped.
external_system_instance_id	The external system id of each instance. For example, a firm may have two instances of iManage Work on their servers.
external_system_role_id	The id of the external system role from the external_system_role table.
is_deleted	Marks if the role mapping is deleted from CAM. 0 is not deleted. 1 is deleted.
created_user_id	The user id who created the external system role mapping.
last_modified_user_id	The user id who last modified the external system role mapping.
created_date	The date created
last_modified_date	The date last modified.

...