I'm wanting to setup some reports relating to the use of Knowledge in our department. I've done a few but am stuck with the following;
I'm wanting to report on how many Incidents have been resolved using knowledge. We have a separate report on general Knowledge use (using the kb_use table), but I'm wanting purely knowledge used to resolve incidents.
I've currently trying to report using the "Relevant Document Detail [cxs_rel_doc_detail]" table. I have the following conditions setup.
It's less than ideal. I have the 'relevant document contains 00' as i'm only trying to capture incidents. it picks up on our incident naming which is currently INC0034799. Without the 00 caveat it picks up on other artifacts.
I'm sure there is a much better way to achieve what i'm wanting to do. I've searched the forums but couldn't find anything that helped. Any suggestions would be appreciated. Excuse my ignorance, I'm learning as i go with this.
We use Knowledge Applied to Tasks [m2m_kb_task] as replied by Slawek.Radziewicz.
