Table Usage
Knowledge Content
To retrieve Knowledge Content the connector accesses the tables:
- kb_knowledge: Table with the Knowledge Articles.
- kb_category: Table with the details of the Article’s category.
- kb_knowledge_base: Table for the Knowledge Base information.
- sys_attachment: Table to extract attachments.
- sys_attachment_doc: Table to extract attachments.
- kb_uc_cannot_read_mtom: Table to relate Cannot Read user criteria and Knowledge Bases.
- kb_uc_can_read_mtom: Table to relate Can Read user criteria and Knowledge Bases.
- kb_uc_can_contribute_mtom: Table to relate Can Contribute user criteria and Knowledge Bases.
- sys_user_role: Table to extract the Public role sys id.
- user_criteria: Table of user criteria.
- sys_user: Table with the detail of users (Used for author details).
The roles needed to access these tables are: Knowledge, Knowledge_Admin and User_Admin or Itil.
Catalog Content
To retrieve Catalog Items’ content the connector accesses the tables:
- sc_cat_item: Table with the Catalog Items.
- sc_category: Table with the details of the Catalog item’s category.
- sc_catalog: Table with the Catalog of the Catalog Items.
- sc_cat_item_user_criteria_mtom: Table to relate Available For user criteria and Catalog Items
- sc_cat_item_user_criteria_no_mtom: Table to relate No Available For user criteria and Catalog Items
- sys_attachment: Table to extract attachments.
- sys_attachment_doc: Table to extract attachments.
- user_criteria: Table of user criteria.
The roles needed to access these tables are: Catalog and User_Admin or Itil.
These are the tables required to extract the list of users that can access Knowledge Bases.
- kb_knowledge_base
- u_acl_table_users (custom table and depends on a custom webservice)
The roles needed to access these tables are: Knowledge_Admin.