How to get a report reflecting incidents closed without KBA attached

[DaniJ]

Good afternoon,

I need assistance with a report in service now related to KBA. There is not an option in SN that reflects INC or SCtasks where KBA was not attached. I am able to see KBA that were used by getting data from Knowledge applied to Tasks [m2m_kb_task] but this does not reflect KBA not used. Any assistance would be appreciated.

[Neeraj31 · Accepted solution]

Hi Danijela,

Select the table name as "Incident" in report and in filter, do changes in Related list condition.

Select table as "Attached Knowledge" and select "Equal to 0" above table name.

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

Thanks and Regards,

Neeraj Sharma

[Neeraj31]

Hi Danijela, Please share screenshot of your condition.

[DaniJ · Accepted solution]

Please see below,

This actually pulled the data that I needed thank you for your assistance.