Configuration item - where do I see the knowledge base articles linked to a CI?

Ulrich Schulte
Tera Contributor

I created a couple of knowledge base articles linked to a certain configuration item. 

 

When I now open this CI in the CMDB, I would expect that the linked KB articles are shown somewhere here...but I cannot find them. Does anybody know how to see them?

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hi @Ulrich Schulte ,

 There is no Existing relationship exists as what you are looking at. 

However, Knowledge articles are related to configuration items using m2m_kb_ci table



Here is the custom relationship you can define using

System Definition > Relationships


SandeepDutta_0-1677675481690.png

 


and in query with use the below script

(function refineQuery(current, parent) {

 

// Add your code here, such as current.addQuery(field, value);

 

current.addQuery('cmdb_ci', parent.sys_id);
current.addQuery('kb_knowledge.workflow_state', '!=', 'retired');
current.addQuery('kb_knowledge.u_approval', '!=', 'Rejected');

 

})(current, parent);

View solution in original post

3 REPLIES 3

Community Alums
Not applicable

Hi @Ulrich Schulte ,

 There is no Existing relationship exists as what you are looking at. 

However, Knowledge articles are related to configuration items using m2m_kb_ci table



Here is the custom relationship you can define using

System Definition > Relationships


SandeepDutta_0-1677675481690.png

 


and in query with use the below script

(function refineQuery(current, parent) {

 

// Add your code here, such as current.addQuery(field, value);

 

current.addQuery('cmdb_ci', parent.sys_id);
current.addQuery('kb_knowledge.workflow_state', '!=', 'retired');
current.addQuery('kb_knowledge.u_approval', '!=', 'Rejected');

 

})(current, parent);

Fair enough...but what I don't understand is "no Existing relationship exists". 

 

What I did at my KB Article is this (see screenshot below)...so wouldn't it make sense, that this KB article would show up at the CI "Oracle EU" somewhere instead of the need to look up any other table or define relationships? Why does the field "configuration item" exist on a KB article, if it does not create a relationship?

 

UlrichSchulte_0-1677679262576.png

 

Community Alums
Not applicable

Hi @Ulrich Schulte ,

 Just having a field on a form doesn't means it would cerate a relationship automatically.