Create a report for Knowledge articles that are not attached to Incidents

[gvsivasaivi]

Hi Team,

I am trying to create report that KB articles that are not incidents, so that we can update the KB's to the Incidents which are not updated.

But whatever data source I use I am getting results as '0'. I have "Incidents", "Task" & "kb_knowledge" data source I am getting zero results. I don't know what I'm doing wrong here like selecting incorrect filter conditions or Data Sources.

Please share your knowledge on this to resolve my issue with reports.

Regards,

G. Sai Vignesh

[Tejas Adhalrao]

hi @gvsivasaivi  ,

I think the main issue is the way the tables are being combined. If the requirement is to report on KB articles that are not related to Incidents, you should start from the kb_knowledge table, not Incident or Task.

Create the report on kb_knowledge and first confirm you can get results with a simple filter such as Active = true. Then add the relationship condition based on how your KB articles are linked to Incidents.

If there is no direct reference/relationship between kb_knowledge and Incident in your implementation, using Incident/Task as the data source will not give you the expected result. In that case, you may need a database view or another reporting approach to compare the two datasets.

I would first verify how your KB article is associated with the Incident — for example, Knowledge field, Related Knowledge, or another custom relationship. Once that is clear, the exact report filter can be defined.

If this helps, please mark it as Helpful and accept the solution.
Regards,
Tejas