I’m using the azure monitor datasource which has a query variable subscriptions() which returns all the subscriptions that are available, it appears to return the friendly name and guid of the subscription.
I would like to take part of the friendly name returned to use in subsequent variables but it appears the subscription is only available as the guid.
E.g. my subscription() call returns:
"app-prod,0000-guid-0000", "app-uat,0000-guid-0001", "app-dev,0000-guid-0002"
I would like to take just the “prod”, “uat” and “dev” for subsequent calls but can’t find a way to do this, is it possible?