Specify databases for custom metric using wildcards
We have multiple databases for each of our clients - each type of databases uses the same schema and follows a consistent naming convention. For example:
XXXXMain
XXXXExtra
XXXX_Management
YYYYMain
YYYYExtra
YYYY_Management
I want to add a custom metric that only applies to "_Main" schema so in order to choose databases to collect from I need to specify each database explicitly. This proves challenging as the number of clients grows and we add more servers / instances to our environment.
It would be preferable if i could instead use some form of wildcard to specify databases (e.g. "%Main" or "*Main") in order to automatically collect this metric from all current and future databases following this naming convention.
A bit of an edge case that would make things a lot more complicated for all users