DELETE FROM [ION_Data].[dbo].[Channel]
WHERE [RecorderID] IN (SELECT [ID] FROM [ION_Data].[dbo].[Recorder] 
WHERE [SourceID] IN (SELECT [ID] FROM [ION_Data].[dbo].[Source] 
WHERE [Name] IN (
'group_name.actual_source_name'
)))
 
DELETE FROM [ION_Data].[dbo].[RecorderState]
WHERE [RecorderID] IN (SELECT [ID] FROM [ION_Data].[dbo].[Recorder]
WHERE [SourceID] IN (SELECT [ID] FROM [ION_Data].[dbo].[Source]
WHERE [Name] IN (
'group_name.actual_source_name'
)))
 
DELETE FROM [ION_Data].[dbo].[Recorder]
WHERE [ID] IN (SELECT [ID] FROM [ION_Data].[dbo].[Recorder]
WHERE [SourceID] IN (SELECT [ID] FROM [ION_Data].[dbo].[Source]
WHERE [Name] IN (
'group_name.actual_source_name'
)))
 
DELETE FROM [ION_Network].[dbo].[IAS_MeasurementAddress]
WHERE [SourceID] IN (SELECT [SourceID] FROM [ION_Network].[dbo].[SRC_Source]
WHERE [Name] IN (
'group_name.actual_source_name'
))