Versions Compared

Key

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

Table Usage


For 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.
  • 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 need it to access these tables are: Knowledge, Knowledge_Admin and User_Admin or Itil.

The Service Now connector will crawl content from Service Now. 

Panel
titleOn this page

Table of Contents

Features


Some of the features of the Service Now connector include:

  • Supported elements retrieval using the RESTful API
  • BASIC authentication supported


Content Retrieved


The Service Now connector retrieves several types of documents, listed below are the inclusions and exclusions of these documents.

Include

    • Knowledge Articles and Attachments 
    • Catalog Items and Attachments

Table Usage


For 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.
  • 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 need it to access these tables are: Knowledge, Knowledge_Admin and User_Admin or Itil.


For 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.
  • sys_attachment: Table to extract attachments.
  • sys_attachment_doc: Table to extract attachments.

 

The roles need it to access these tables are: Catalog.

Limitations 


Due to API limitations, Service Now connector has the following limitations:

  • Only public Catalog Items will be crawled.
  • Only public Knowledge Articles are retrieved by the connector.
    • We support ACLs only for Knowledge Articles using the Knowledge Criteria; this means we must add the Knowledge Base id as ACL for each document, then using Group Expansion we extract the list of users that are allowed to access the particular Knowledge Base.
    • Due to time constraints, the security support for other content was postponed for a later release.


Future Development Plan


The following features are not currently implemented, but are on the development plan:

  • Non public knowledge articles retrieval.

Anything we should add? Please let us know.