Azure Resource Graph Explorer is a powerful tool that lets you interact with the resources across multiple subscriptions.
You can browse it through the All. Resources screen -> Open Query option.
Then there are many pre defined set of queries that allows you to begin easily.
The following query lets you find all the resources by a tag 'production'
| where tags.environment=~'production'
| project name
If you have configured tags correctly, you can see all your production resources with this.
Apart from the results view, it shows the chart view as well for possible results.
Once you are satisfied with it, you can save the query as a private or a shared query via Save Query windo.