Confluence Usage Stats - Which table?

Trevor Hunt
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 14, 2013

Anyone out there happen to know which table the Confluence Usage Stats plugin stores it's data? I'd like to access this via the SQL macro so I can slice and dice the data a few ways.

3 answers

1 vote
Matthew J. Horn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 14, 2013

First place I'd check is the bandana table. Lots of macros seem to store their data in there. In your SQL, use all caps ("BANDANA") for the table name.

0 votes
Richard Gee October 30, 2017

It doesn't use the database, it uses Lucene to store the data.

0 votes
Ihor Tretyakov June 5, 2016

Hi, in BONDANA:

SELECT TOP 1000 [BANDANAID]
,[BANDANACONTEXT]
,[BANDANAKEY]
,[BANDANAVALUE]
FROM [Confluence].[dbo].[BANDANA] 
where [BANDANAKEY]like 'plugin.manager.state.Map'

But the code in table like this:

<map>
  <entry>
    <string>confluence.macros.html:html-migration</string>
    <boolean>true</boolean>
  </entry>
  <entry>
    <string>tac.confluence.languages.fr_FR</string>
    <boolean>false</boolean>
  </entry>
  <entry>
    <string>confluence.macros.html:html-xhtml</string>
    <boolean>true</boolean>
  </entry>
  <entry>
    <string>tac.confluence.languages.es_ES</string>
    <boolean>false</boolean>
  </entry>
  <entry>
    <string>tac.confluence.languages.ja_JP</string>
    <boolean>false</boolean>
  </entry>
  <entry>
    <string>com.adaptavist.plm.plugin.plm-plugin</string>
    <boolean>false</boolean>
  </entry>
  <entry>
    <string>confluence.macros.html:html-include</string>
    <boolean>true</boolean>
  </entry>
  <entry>
    <string>tac.confluence.languages.de_DE</string>
    <boolean>false</boolean>
  </entry>
  <entry>
    <string>confluence.macros.html:html</string>
    <boolean>true</boolean>
  </entry>
  <entry>
    <string>com.atlassian.confluence.plugins.confluence-mobile</string>
    <boolean>false</boolean>
  </entry>
  <entry>
    <string>com.atlassian.confluence.ext.usage</string>
    <boolean>true</boolean>
  </entry>
  <entry>
    <string>confluence.macros.html:html-include-xhtml</string>
    <boolean>true</boolean>
  </entry>
</map>

 

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events