1 Reply Latest reply on Sep 4, 2020 3:48 AM by Paul Tipping

    How can I run a statistics report for Footprints (Version 20.19.01) Knowledge Base articles?

    Ashraf Tadrous
      Share This:

      I need to run a statistics usages and feedback report for Footprints (Version 20.19.01) Knowledge Base articles. Is there any way to develop such a report and if so, how this can be done?

        • 1. Re: How can I run a statistics report for Footprints (Version 20.19.01) Knowledge Base articles?
          Paul Tipping

          Running the following query in the database will show how popular a KB article is:

           

          SELECT *

            FROM [fpdb001].[fpdb001_kb_001].[knowledge_artic]

            order by popularity asc

           

          This query will show which tickets are linked to a KB article

           

          SELECT fpdb001_system.defn_ver.defn_ver_name AS Link_type, fpdb001_system.item_reln.from_item_id AS From_ticket, fpdb001_system.v_cntnr_item_active.cntnr_external_name AS [From-Workspace],

                       fpdb001_system.v_cntnr_item_active.item_external_name_en_US AS [From-Item-Name], fpdb001_system.item_reln.to_item_id AS [To-Ticket], v_cntnr_item_active_1.cntnr_external_name AS [To-Workspace],

                       v_cntnr_item_active_1.item_external_name_en_US AS [To-Item-Name]

          FROM   fpdb001_system.item_reln INNER JOIN

                       fpdb001_system.v_cntnr_item_active ON fpdb001_system.item_reln.from_item_defn_id = fpdb001_system.v_cntnr_item_active.item_defn_id INNER JOIN

                       fpdb001_system.v_cntnr_item_active AS v_cntnr_item_active_1 ON fpdb001_system.item_reln.to_item_defn_id = v_cntnr_item_active_1.item_defn_id INNER JOIN

                       fpdb001_system.defn_ver ON fpdb001_system.item_reln.link_type_defn_ver_id = fpdb001_system.defn_ver.defn_ver_id

          where  fpdb001_system.defn_ver.defn_ver_name  = 'ticketSolution'