Locating Jira Service Management's Knowledge Base search statistics through the database

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

Please note the following information is provided as-is. Atlassian Support cannot provide further assistance with the SQL queries described below

The purpose of this Knowledge Base is to provide additional information regarding the following Jira Service Management tables:

AO_0201F0_STATS_EVENT_PARAM
AO_0201F0_STATS_EVENT



When using a Service Management along with Confluence to make use of the Knowledge Base linking functionality, these tables are responsible for keeping track of all searches that are done through the customer portal. Here's how they work:

When a Customer accesses either the Customer Portal or the Issue Creation pages, inputs on the following fields are directly searched through the linked Confluence page

Then, when inputting something on those fields, a search is run on the linked Confluence space in order to look for pages that might help your customer and avoid the creation of a ticket. Here's how these results look on screen:

データベーステーブル

Every search performed on these fields will include a line to the AO_0201F0_STATS_EVENT table, which will look like this:

We can, then, consult the actual value of the search through the AO_0201F0_STATS_EVENT_PARAM table by matching the ID (AO_0201F0_STATS_EVENT) value with the STATS_EVENT_ID (AO_0201F0_STATS_EVENT_PARAM) value. 

select * from "AO_0201F0_STATS_EVENT_PARAM" where "STATS_EVENT_ID" = 4;

Which results in:



Here's the information breakdown of every line included:

searchTimeActual date / time in Epoch timestamp. This value can be converted by tools such as https://www.epochconverter.com/.
pageIdsID of the Confluence pages retrieved as result of the search.
searchTermThe string that was used to generate the search on Confluence's linked page.
originWhere the search originated from within Service Management. smart-portal refers to the Customer Portal section, while request-type-create refers to the Create Request page.
requestTypeNames / requestTypeIdsIf the search is done through the Customer portal, a value for each retrieved Request Type name as well as their ID's is added to the table.
usernameUsername that triggered the search.


This information can be valuable for custom reporting and system administrators interested on the actual data of their userbase searches.


最終更新日 2021 年 6 月 16 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.