I have been asked about being able to report on not just how many times a knowledge document has been "hit" but by whom. Does CASD R12.6 capture this information?
There don't appear to be any field on the SKELETONS table that suggests it does.
Have you looked at any of the OOTB CA Business Intelligence reports within the Knowledge folder?
No, I haven't but that is because we're not using CABI/BOXI for reporting on our environment.
Thank you for the suggestion though.
The following SQL query might help you get started:
BU_TRANS.contact_id = cnt.id
BU_TRANS.DOC_ID = KD.id
KD.ACTIVE_STATE >= 0
KD.ACTIVE_STATE < 100
KD.status_name IN ( 'Published' )
You also might want to research further into the KNOWLEDGE REPORT CARD feature
Thank you Paul, I will check it out.