Query all Additional Fields and their related Templates

Query all Additional Fields and their related Templates

We've had SDP for a few years now and some forms have been made and retired in that time. Most fields are reused but some aren't and I'd like to clean house some.

Is there a query I can run that will report every Incident/Service Request Additional Field and any templates (active and inactive) each field is added to currently?

This will allow me to see fields that are not used at all and can most likely delete. This is for SDP 12.0 Build 12007, MSSQL.

Thank you!

                  New to ADSelfService Plus?