Used DEF template SQL

This query lists which templates have been used: SELECT fieldreportdesc.fieldreportname, organisation.orgname, fieldreportdesc.`version`, fieldreportdesc.publisheddate, Count(fieldreport.fieldreport_guid), fieldreportdesc.isactive FROM fieldreport Inner Join fieldreportdesc ON fieldreportdesc.fieldreportdesc_guid = fieldreport.fieldreportdesc_guid Inner Join organisation ON organisation.org_guid = fieldreportdesc.org_guid GROUP BY fieldreportdesc.fieldreportname, organisation.orgname, fieldreportdesc.`version`, fieldreportdesc.publisheddate

If any of them are inactive then you need to:

1. Activate them in the Customisation menu;
2. Open Template Designer;
3. Drag them in and save as file;
4. Inactivate them in the Customisation menu;