select T1.id as backup_id, T1.job_name, t2.id as point_id, T3.id as OIB_id, t3.point_id from dbo.[Backup.Model.Backups] as t1 full outer join dbo.[Backup.Model.Points] as t2 on t1.id = t2.backup_id left outer join dbo.[Backup.Model.OIBs] as t3 on t2.id = t3. point_id where t1.id in ( select backup_id from [Backup.Model.ViCloudTenantBackups] where [quota_id] in ( select id from [Backup.Model.ViHardwareQuotas] where tenantId = (select id from dbo.tenants where name = [i]'%TenantName%[/i]'))) and t3.id is null
EXEC [dbo].[Backup.Model.DeleteBackupChildEntities] '064BFB1C-7A1E-42C9-BAD4-40629F6C4048'
EXEC [dbo].[Backup.Model.DeleteBackup] '064BFB1C-7A1E-42C9-BAD4-40629F6C4048'
Users browsing this forum: tsightler and 37 guests