How to find all user defined templates in confluence ?

Question

I have Confluence admin access.

Can I find list of all user defined templates of different spaces in confluence ?

Is it possible to use or move template of one space to another space  ?

Andrew Yeaman · Answer

I have used the following in SQL:

SELECT CONCAT('[', s.SPACEKEY, ':]') Space, 
s.SPACEKEY SpaceKey, 
s.SPACETYPE Type, 
s.SPACESTATUS Status,
t.TEMPLATENAME 'Template Name',
format(t.LASTMODDATE, 'dd-MMM-yyyy') 'Last Modified',
isnull(cu.display_name, um.lower_username) 'Last Modified By'
FROM PAGETEMPLATES t
JOIN SPACES s on t.SPACEID = s.SPACEID
LEFT JOIN user_mapping um ON t.LASTMODIFIER = um.user_key
LEFT JOIN cwd_user cu on um.lower_username = cu.lower_user_name
Order By s.SPACENAME

Amal - Seibert Solutions · Answer

Hi there,

Is there still no possibility to get a list of all space templates?
Neither with SQL nor with REST API?

Shouldn't it be possible to get it from the DB?

I didn't verfy the SQLs yet, but I think they should work.

select * from spaces where PAGETEMPLATES is not NULL

select * from PAGETEMPLATES p, SPACES s

where p.PAGETEMPLATEID = s.PAGETEMPLATES

PAGETEMPLATESTEMPLATEIDCONTENT_LABELPAGETEMPLATEIDFK28KIFOKT21QD9GES0Q0WV0FB9PRIMARY_KEY_BCPAGETEMPLATESTEMPLATEIDPAGETEMPLATESPREVVERFK4WGWY1DQCI8RCWAD4TNQBGLT8PRIMARY_KEY_BCSPACESSPACEIDCONTENTSPACEIDFKLMWEU06NFT59G7MW1I1MYORYSPRIMARY_KEY_92SPACESSPACEIDNOTIFICATIONSSPACEIDFKMQE1PHE52XWQC4HK4IB8P9EH6PRIMARY_KEY_92SPACESSPACEIDPAGETEMPLATESSPACEIDFK18A1D37PVQ2O9HU5X3TPS97MXPRIMARY_KEY_92SPACESSPACEIDSPACEPERMISSIONSSPACEIDFKBI3X723M8FBGOKO3S84F9ODDLPRIMARY_KEY_92

Best, 
Amal

Sam Lucas_lcc1wy · Answer

Hi @Sushmitha & @Gaby ! I am a new PM for Confluence Templates! I am exploring template permissions, moving templates across spaces, etc. I'd enjoy a quick zoom call with each of you if you're interested an available to learn about your desired functionality and specific templates use cases! Please book a time with me! thx.