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.
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.
It doesn't use the database, it uses Lucene to store the data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.