--SELECT * FROM [Minion].[DBMaintDBGroups]
--SELECT * FROM Minion.BackupLogDetails ORDER BY ID DESC;
--TRUNCATE TABLE [Minion].[DBMaintDBGroups]
--TRUNCATE TABLE Minion.BackupLogDetails

CREATE PROCEDURE ExcludeDBs

AS

DECLARE @currDB varchar(100),
		@DBSize DECIMAL(18,2),
		@SQL nvarchar(200),
		@GroupName VARCHAR(200),
		@SizeThreshold DECIMAL(18,2); --IN GB.

SET @GroupName = 'AvamarExcludes';
SET @SizeThreshold = 1.0;

DECLARE DBs CURSOR
READ_ONLY
FOR select [NAME] from sys.databases
where 
database_id > 4

OPEN DBs

	FETCH NEXT FROM DBs INTO @currDB
	WHILE (@@fetch_status <> -1)
	BEGIN

		EXEC [Minion].[DBMaintDBSizeGet] 'Backup', 'Full', @currDB, @DBSize = @DBSize OUTPUT;
		--SELECT @currDB, @DBSize;

		IF @DBSize > @SizeThreshold
			BEGIN
				IF NOT EXISTS (SELECT 1 FROM Minion.DBMaintDBGroups WHERE Action = 'Exclude' AND MaintType = 'Backup' AND GroupName = @GroupName AND GroupDef = @currDB AND IsActive = 1)
					BEGIN
						INSERT Minion.DBMaintDBGroups([Action], [MaintType], [GroupName], [GroupDef], [Escape], [IsActive], [Comment])
						SELECT 'Exclude', 'Backup', @GroupName, @currDB, NULL, 1, 'Exclude for Avamar';
					END
			END

		IF @DBSize <= @SizeThreshold
			BEGIN
				DELETE FROM Minion.DBMaintDBGroups WHERE Action = 'Exclude' AND MaintType = 'Backup' AND GroupName = @GroupName AND GroupDef = @currDB AND IsActive = 1;
			END
		
FETCH NEXT FROM DBs INTO @currDB
	END

CLOSE DBs
DEALLOCATE DBs