[HELP NEEDED]A query to list all the projects with their group details

Hi I run a gitlab CE managed instance and uses sub groups to categorise projects under different business units etc.


Recently i have been asked to list all the repositories in gitlab instance along with its full path to come up with some audit report .I will feed that in to excel or something like that to create a report .Is there a query or script i can use to pull these details ?