User TableThis table contains all the users within CAM. Query the table by: select * from user limit 100 ^Use the user Query type | Info |
|---|
Important: Don’t type users as the table name; this is an old antiquated table and you won’t get proper results. |
User_Groups TableThis table contains all the user group information within CAM. Query the table by: select * from user_groups limit 100 ^Use the groups Query type Column | Description |
|---|
id | Displays the row number of the entry in the user_group table | userId | Displays the user id associated to the user name. This is auto-generated by CAM. | userSystemId | Displays the user name | groupId | Displays the user id associated to the user name. This is auto-generated by CAM. | groupSystemId | Displays the group name the user is associated to. | subscriberId | Displays the tenant subscriber Id | system | Displays the external system | repositoryId | Displays the repository name | documentDbName | Displays the database name | flag | | created_on | Displays the date the user was added to the group | created_by | modified_on | Displays the last update date | modified_by | N/A | metadata | N/A | sourceId | Displays the database name | repositoryName | Displays the repository nameColumn | Description |
|---|
id | Displays the row number of the entry in the user table | userId | Displays the user id associated to the user name. | userName | Displays the user name | email | Displays the user email Id | office | Displays the office to which the user belongs | title | Displays the title currently associated with the user | phone | Displays phone number currently associated with the user | location | Displays the location currently associated with the user | isExternalN/A | Is this an external user? | userType | Displays the user type (Internal/External) | userContainerType | Displays the container type | extContainerId | Displays the external container id | ExtContainerName | Displays the name of the external container | isCamUser | Displays whether the user is an active CAM user | extId | Displays the external id associated with the user | metadata | Any metadata added/changed/updated/deleted | createdDate | Displays the user creation date | editedDate | Displays the last date the user was edited | createdByUserId | Displays the user id that created the user | createdByUser | Displays the user name that created the user | lastChangeUserId | Displasy the user id that last changed the user | lastChangeUserId | Displasy the user id that last changed the user | camCreateDate | Displays the date in which the user was created in CAM | camCreatedBy??? | Displays the user that created the user record in CAM. | camEditedDate | Displays the last date the user was edited in cam | camEditedBy?? | Displays the user that last edited the user record in CAM | extSystemId | Displays the id of the external system. | subscriberId | ?? |
|