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;

NavBox Upgrade