Scan_template_id & scan schedule config

I’m trying to find what scan templates are in use in our environment.

I don’t think the site template config is the correct place to look as schedules can be saved to use whatever template is available.

Looking at the data model it appears the scan_template_id is only linked to the site config and not the schedule config.

How can I find all the schedules and the scan templates they’re configured for?