Confluence trick to create pages from blueprint templates

You can easily create a HTML Link or ACTION BUTTON to create faster a page from Blueprint Template. PUT THIS URL in the LINK: https://jira.XXX.XXX/wiki/pages/createpage-entervariables.action?templateId=XXXXXX&spaceKey=YYYYY&title&newSpaceKey=YYYYYY&fromPageId=ZZZZ Replace the XXXXX variable by the ID of the Blueprint Template Replace the YYYYY variable by the ID of the Space Replace the ZZZZZ variable by the ID of the…

Read More

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