View source for Query unused forms datastores processes

Show forms with 0 tickets in teh last 24 months (see fixed date in query !!)
 
SELECT * FROM [Form] WHERE [Id] NOT IN (
SELECT [FormField].[Form_Id]
  FROM [FormInstanceValue], [FormField], [FormInstance]
  WHERE [FormInstanceValue].[Field_Id] = [FormField].[Id]
  AND [FormInstanceValue].[FormInstance_Id] = FormInstance.Id
  AND [FormInstance].[LastUpdate] > '2020-12-12'
)


 
Query to show processes without tickets in the last 24 months (see fixed date in query !!)
 
SELECT * FROM [Process] WHERE [Id] NOT IN (
SELECT [ProcessInstanceStep].[OriginalProcessId]
  FROM [ProcessInstanceStep], [ProcessInstance]
  WHERE [ProcessInstanceStep].[ProcessInstanceId] =  [ProcessInstance].[Id]
  AND [ProcessInstance].DateStarted > '2020-12-12'
)
 
Unused datastore parameters in selection fields (except the retired forms):
 
SELECT * FROM [Parameter] WHERE [Name] NOT IN (SELECT COALESCE([SelectionParameter], '') FROM [FormField], [Form] WHERE [FormField].[Form_Id] = [Form].Id AND [Form].IsRetired = 0)