CA Service Management

 View Only
  • 1.  statistics on knowledge document hits

    Posted Feb 01, 2015 03:53 PM

    Hi,

    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.

     

    Thank you

     

    David



  • 2.  Re: statistics on knowledge document hits

    Broadcom Employee
    Posted Feb 02, 2015 04:54 PM

    Have you looked at any of the OOTB CA Business Intelligence reports within the Knowledge folder?



  • 3.  Re: statistics on knowledge document hits

    Posted Feb 02, 2015 05:13 PM

    Hi Paul,

    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.

     

    David



  • 4.  Re: statistics on knowledge document hits
    Best Answer

    Broadcom Employee
    Posted Feb 03, 2015 03:08 PM

    The following SQL query might help you get started:

     

    SELECT

      BU_TRANS.DOC_ID,

      BU_TRANS.document_title,

      BU_TRANS.contact_combo_name,

      PdmString(BU_TRANS.contact_id),

      BU_TRANS.document_hits,

      BU_TRANS.id,

      BU_TRANS.document_vote_count,

      BU_TRANS.document_avg_rating,

      cnt.department_name,

      KD.ACTIVE_STATE,

      cnt.combo_name,

      cnt.email_address,

      PdmString(cnt.id)

    FROM

      BU_TRANS,

      cnt,

      KD

    WHERE

      (

       BU_TRANS.contact_id  =  cnt.id

       AND

       BU_TRANS.DOC_ID  =  KD.id

       AND

       KD.ACTIVE_STATE  >=  0

       AND

       KD.ACTIVE_STATE  <  100

       AND

       KD.status_name  IN  ( 'Published'  )

      )



  • 5.  Re: statistics on knowledge document hits

    Broadcom Employee
    Posted Feb 03, 2015 03:10 PM

    You also might want to research further into the KNOWLEDGE REPORT CARD feature



  • 6.  Re: statistics on knowledge document hits

    Posted Feb 03, 2015 03:14 PM

    Thank you Paul, I will check it out.