Listing Templates in use

Is there a method for listing all templates that are in use - i.e. selected for any survey? I'm looking for a way to cull our unused custom templates.

---john---

Hi
I have not yet come across with such a method present in current version of LimeSurvey. I guess you will have to write it manually , if you actually need it.

--
cheers
amit

Sorry, no, you'll have to do it the painful way

The following solution is not painful if you understand a tiny bit of mysql:
Run the following sql statement in phpmyadmin, R or php

select folder,count(s.template) from
(SELECT * FROM `lime_templates` left join lime_surveys on folder=template
union
select * from lime_templates right join lime_surveys on folder=template ) as s
group by s.folder

This leads to a list of templates and the number of surveys that uses this template:
basic 0
bluengrey 0
citronade 1
clear_logo 0
default 2
DigiPsy 10
..
..

(I am not very good in sql, probably this can be done in a simpler way, but this works)
Frans