How Do I Copy the KnowledgeBase Table?

rhett1 · ‎03-20-2017

Is it possible and can I copy KnowledgeBase (kb_knowledge_base) from what is OOB to another copy? Here is why:

I have some very specific requirements to modify this table, but our IT admin indicated they do not want us to touch this table unless we can create our own copy (e.g. u_kb_knowledge_base). Any pointers are greatly appreciated!

Alikutty A · ‎03-20-2017

Your requirements can be achieved with the oob knowledge base table itself. You can create a new workflow on the KB, new CI specific View for the knowledge articles which can be used to add the field and the pop-up validation in it.

This won't affect the existing behavior as you are adding new elements and not modifying existing ones. I suggest you talk once with your IT Admin to reconsider these options.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

View solution in original post

Alikutty A · ‎03-20-2017

Hi,

What specific requirement are you trying to achieve on knowledge base table? You can make the table extensible and extend a new table from it so all features remain intact and add additional features to it.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

rhett1 · ‎03-20-2017

The two chief requirements for the creation of a Business Continuity/Disaster Recovery KB are:

This KB will require a custom workflow different from what is used by KB OOB.

The UI Action for submitting/reviewing an article will need to check the Valid To date and provide pop-up validating if this is correct.

Alikutty A · ‎03-20-2017

It is always best to go OOB as you can stay updated with Service Now else it would create you maintenance problems.

You can create a new knowledge base and tag a new workflow to it(This wont impact the knowledge base). This is possible without creating a new table and you can add specific read, write access to this knowledge base so other users won't see it.

What validation you require on valid to? It always saves valid dates in it.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

rhett1 · ‎03-20-2017

Thank you.

The validation is really a simple pop-up to ask the person submitting the article, if the valid to date is correct.

There is one other requirement I failed to mention:

I need to modify the KnowledgeBase form to include the CI Owner, when a specific CI is selected from the CMDB. The CI Owner in turn becomes the article owner.