Clarity Service Management

Expand all | Collapse all

Can someone provide me with the tables that apply for Knowledge Managment? Thanks!

  • 1.  Can someone provide me with the tables that apply for Knowledge Managment? Thanks!

    Posted 05-20-2016 02:53 PM

    We are trying to migrate our knowledge module to prod, and we need to identify the fields associated with this module.

    This will help us also to get the right way to create the documents in o rder to have a good response from the report tool.

     

    Thanks!



  • 2.  Re: Can someone provide me with the tables that apply for Knowledge Managment? Thanks!

    Posted 05-23-2016 08:25 AM

    Hi,

    Majority of KB tables are prefixed with kt, kd  with the main table be the skeletons table

     

    That say the I will strongly recommend you to move your KB data using the export/import function vs. doing anything in the mdb directly with high risk of corrupted data at the end

     

    My 2 cents

    /J



  • 3.  Re: Can someone provide me with the tables that apply for Knowledge Managment? Thanks!

    Posted 05-23-2016 02:51 PM

    Rocio, SDM/KT use the following tables for knowledge documents:

    ADMIN_TREE

    BU_TRANS

    CI_ACTIONS

    CI_ACTIONS_ALTERNATE

    CI_BOOKMARKS

    CI_DOC_LINKS

    CI_DOC_TEMPLATES

    CI_DOC_TYPES

    USP_PREFERENCES

    CI_PRIORITIES

    USP_PROPERTIES

    CI_STATUSES

    CI_WF_TEMPLATES

    EBR_ACRONYMS

    EBR_DICTIONARY

    EBR_DICTIONARY_ADM

    EBR_FULLTEXT

    EBR_FULLTEXT_ADM

    EBR_LOG

    EBR_METRICS

    EBR_NOISE_WORDS

    EBR_PATTERNS

    EBR_PREFIXES

    EBR_PROPERTIES

    EBR_SUBSTITS

    EBR_SUFFIXES

    EBR_SYNONYMS

    EBR_SYNONYMS_ADM

    ES_CONSTANTS

    ES_NODES

    ES_RESPONSES

    ES_SESSIONS

    INDEX_DOC_LINKS

    KD_ATTMNT

    kdlinks

    LONG_TEXTS

    O_INDEXES

    P_GROUPS

    SHOW_OBJ

    SKELETONS

    ///////////////////////////////////////////////////////

    Technical Reference Guide has some info on what fields

    of tables are and how they are related. I post them here for

    better understanding of the tables of the KT module not

    intend for you to manually extract from one env and load to

    another. You would need to use KT import/export utility for

    same level env move or follow the standard procedure to migrate from one version to a later one. Thanks _Chi