Creating a Report for seeing how many CMDB Services have a created KB, and not.

[Andreas_Aurobay]

main question:

Creating a Report for seeing how many CMDB Services have a created KB, and not?

i have trouble finding how i can get this info, from services or from knowledge articles?

using that i can figure out how to create one that shows the ones that are created to a service, in a long normal list i can sort manually. 

anyone can get me on the right track here? how do i do it?

[Mark Manders · Accepted solution]

You can create a report on table 'cmdb_ci_service', assuming that's the table and use the related list conditions to check on Knowledge (select Knowledge -> Configuration item) and set the default 'Greater than or Equal to 1' to 'Equal to 0' and it will show you all services where no article is written for:

[Andreas_Aurobay]

This worked perfectly! this was the part i was shown and all correct! thank you!!

important notice, the equal to 1 thing he is refering to is the blue part above the drop down menu. easily missed

[Andreas_Aurobay]

testing! lots of details on this that i dont know yet, but understand its possible then, and i see how it works. 
also got a contact inside our dev team that can give me a hand, il come back and mark it if it worked, thank you!