Linking teams with projects

[raymond.cooper]

I need to see what teams are linked to what projects. I’m not seeing this in the OD portal. Is there a way to query the database for this info?
Thanks.

Glenn

[garrett.dass]

Hi @raymond.cooper,

Thanks for reaching out and welcome to the Octopus community.

We have a few ways you could potentially accomplish this.
The first is here using a project permissions report: Project permissions report - Octopus Deploy
This is listed by the user so you would either need to account for that or modify it if teams are necessary.

You could also repurpose this REST API example script as well: OctopusDeploy-Api/RemoveProjectFromTeam.ps1 at master · OctopusDeploy/OctopusDeploy-Api · GitHub

Instead of finding one team, you would have to grab all teams and iterate through them then print out the projects for each team instead of removing the project.

Please let me know if you have any questions.

Regards,
Garrett