Currently we have dozens od plugins, some paid, some free, and multiple projects.
we don't know, if a given plugin is used anymore, and if yes, by which project.
The plugin which is the most important for me, is used as a task in builds plan, so there should be a way to find all projects, and build plans, using that specific task?
Could not find a way to do this, any ideas?
We don't have a feature for that in Bamboo, but you can use the following DB query to search for plan jobs configured to use the given plugin as a task.
SELECT full_key, xml_definition_data
FROM build b
JOIN build_definition bd ON b.build_id=bd.build_id
WHERE xml_definition_data LIKE '%<PLUGIN_KEY>%'
(i) If you need to discover the <PLUGIN_KEY>, please go to Admin > Overview > Manage apps > (your plugin) > app key.
⚠️ We can't assure that this will cover all the plugins you want, given that a plugin will not always create a complete task on its own. Some of them will only add extra features to existing tasks (for these cases the query may not work).
I hope it helps anyway.