Obtaining Confluence metrics & SQL tricks

MySQL query to get the last login of all members of the confluence-users group SELECT distinct u.lower_user_name, l.successdate FROM cwd_user u LEFT JOIN logininfo l ON u.user_name = l.username JOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN spacepermissions sp ON g.group_name = sp.permgroupname WHERE permtype=’USECONFLUENCE’ order by u.lower_user_name; …

Read More

How Do I Remove the Side Bar in Confluence 5?

Enabling the HTML Macro The HTML macro is disabled by default. You’ll need Confluence Administrator or System Administrator permissions to enable this macro. Enabling these macros can make your Confluence site vulnerable to cross-site scripting attacks. You should only turn on these macros if you trust all your users not to attempt to exploit them.…

Read More