How to list projects using given plugin?

[JacekP]

Currently we have dozens od plugins, some paid, some free, and multiple projects. 

The problem:

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?

BR

Jacek

[Daniel Santos]

Hi @JacekP

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.