Create a report for incidents having No incident tasks and atleast one kb article attached.

[Aishwarya Pulas]

Hi , I am knew to servicenow so please handle my question accordingly.

I have a requirement to create a report that will give me the number of Incidents that do not have any Incident Tasks attached and atleast have one KB article attached to it.

This is not possible straight out from filter as both are related list conditions. 

Any help will be much appreciated. Thanks in Advance!

[AndersBGS · Accepted solution]

Hi @Aishwarya Pulas ,

You can create your report in report designer utilizing the incident task table. From here, you can dot-walk to the incident, and filter by KB article needs to be attached. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Aishwarya Pulas]

Thank you @AndersBGS , the suggestion was helpful but I had to create a datasource between incident task and  incident.