Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================
(Write here your question/remark)Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================
(Write here your question/remark)Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================
(Write here your question/remark)Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================
(Write here your question/remark)Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================
(Write here your question/remark)Please help us help you and fill where relevant:
Your LimeSurvey version: 6.17.16
Own server or LimeSurvey hosting: own server
Survey theme/template:
==================
Hi everyone,

Within my organisation we have our own LimeSurvey server. My colleague and I are administrators and we were wondering if there is an easy way to find out which themes are being used by all the surveys that we have. Over the years many new themes have been created and we want to delete the ones that are not being used. However, we have so many surveys that it would take a long time to look for the theme of each survey seperately. Maybe one of you has experience with this? Thanks in advance!

I think the best approach is switching them off and wait for complaints....

Jokes aside, I don't think there is something in the interface that will show you a statistics about that. You might have to consult the database directly, maybe.

Let's see if someone else has a better idea.

There is no functionality inside the GUI to get a usage report or filter surveys for theme usage.
I'm not aware of t a workaorund in LS6 or LS7. Perhaps others can

Trying to use the RemoteAPI and write a tool to collect the data might work.
www.limesurvey.org/manual/RemoteControl_2_API
Via get survey porperties the template name (former name for theme) should be there.
api.limesurvey.org/classes/remotecontrol...et_survey_properties

Or you access the database directly via a report tool and extract the data there.

A feature request would be a good idea. Perhaps the survey list can add a column to show the theme name. That way the filter could be used.
Perhaps that can be done via a plugin too.

I don't think this can be reliably solved with a simple database query.

A survey may use , and themes themselves can extend other themes, so a theme that is not directly assigned to any survey may still be required as a dependency.

So "not directly used" does not necessarily mean "safe to delete".A proper solution would need to resolve the effective theme for each survey and also check the theme inheritance/extension dependencies.

This might be a good feature request for a "Theme usage/dependency" overview in the admin interface.

As a short-term solution, this could probably also be implemented as a plugin that generates such a report.

rsmits wrote:

However, we have so many surveys 

How many surveys?

Listing all survey with the used theme (theme is in databasetable prefix.surveys variable template) is a start.
That is usually one SQL query. You can sorting the results by theme name and already see which theme is not used.
Checking the different levels of dependencies can be done via looking at the themes admin section.

Sometimes it can be easier to install a separate LS7 installation and move all relevant thing from the old LS6 to the new server over time.
The new LS7 editor only works with themes optimized for it. Not sure we will see a big adoption of the new editor in LS7.
But introduction of LS7 can be a good way to get rid of old and unused stuff as well.