Setting up a Variable for Organisations in Grafana

Hello,
i am not sure if this has already been answered, in that case i was not able to find it here.

I want to filter my Dasboards by Organisation, setting this up via a variable should be the way.
but, for the life of me i am unable to create a query that extracts a list of active Organisations.

Can anyone of you give me a push in the right direction?

Kind regards
Wolf

Infos:

Zammad Version 6.5.x.c81b1eef4f.saas.
Zammad and Grafana are both cloudbased.