Report on Incident Knowledge table

[ashwanikumar]

Hi All,

I need to create reports on Knowledge Article usage. I need to show the list of incidents attached to a knowledge article.

Is there any table which saves knowledge & incident linkage records so that i can create report on it?

Thanks,
KUMAR

[Allen Andreas]

Hi,

This table houses data like: relevant to...and will list the task that it was attached to.

cxs_relevant_doc_task

Please mark reply as Helpful/Correct, if applicable. Thanks!

[gyedwab]

Allen is right about the cxs_relevant_doc_task table, although if you want the list grouped by the article you may want to look at the table cxs_rel_doc_detail, dot-walking to the parent "Relevant Document" table to get the "Relevant To" field.

Unfortunately, there are some limitations because ServiceNow stores the "documents" as a document ID field, which ServiceNow can't dot-walk. I used Explore Analytics (a real-time integrated reporting tool) to use a "lookup" function to pull additional fields:

[Allen Andreas]

Nice. But they said they want to look at the incidents the articles are attached to. So in my method, they can group by the "Related to" field...which keeps the data together in their list.

So sort of the other way around than what you're talking about.

Good info though on your end.

Thanks!