MERGE INTO TSMAlert.FILESPACESWITHOUTBACKUP i
	USING (
		SELECT
			q.Alert_Config_ID,
			q.DUMPDATE,
			
			q.BACKUP_END,
			q.BACKUP_START,
			q.CAPACITY,
			q.DELETE_OCCURED,
			q.FILESPACE_HEXNAME,
			q.FILESPACE_ID,
			q.FILESPACE_NAME,
			q.FILESPACE_TYPE,
			q.HOURS_LASTBACKUP,
			q.NODE_NAME,
			q.PCT_UTIL,
			q.SERVER_ID,
			q.UNICODE_FILESPACE
		FROM
			TSMALERTCONFIG.FILESPACESWITHOUTBACKUPQUERY q
		WHERE
			q.Client_ID = in_Client_ID
			AND q.Server_ID = in_Server_ID
			AND q.Alert_ID = in_Alert_ID
	) AS q ON i.ALERT_CONFIG_ID = q.ALERT_CONFIG_ID
		AND i.SERVER_ID = q.SERVER_ID
		AND i.NODE_NAME = q.NODE_NAME
		AND i.FILESPACE_NAME = q.FILESPACE_NAME
		AND i.FILESPACE_ID = q.FILESPACE_ID
		AND i.STATUS_ID IN (in_RaisedStatus_ID, in_SnoozedStatus_ID)
	
	--] refresh raised instances:
	WHEN MATCHED AND i.Status_ID = in_RaisedStatus_ID THEN
		UPDATE SET
			i.UPDATED_ON = CURRENT_TIMESTAMP,
			i.UPDATED_BY = 'Alert Engine'
	
	--] re-raise snoozed instances:
	WHEN MATCHED AND i.Status_ID = in_SnoozedStatus_ID AND CURRENT_TIMESTAMP > i.SNOOZE_TIME THEN
		UPDATE SET
			i.STATUS_ID = in_RaisedStatus_ID,
			i.UPDATED_ON = CURRENT_TIMESTAMP,
			i.UPDATED_BY = 'Alert Engine'
	
	--] raise new instances:
	WHEN NOT MATCHED THEN
		INSERT (
			Alert_Config_ID,
			Status_ID,
			Raised_On,
			Dumpdate,
			BACKUP_END,
			BACKUP_START,
			CAPACITY,
			DELETE_OCCURED,
			FILESPACE_HEXNAME,
			FILESPACE_ID,
			FILESPACE_NAME,
			FILESPACE_TYPE,
			HOURS_LASTBACKUP,
			NODE_NAME,
			PCT_UTIL,
			SERVER_ID,
			UNICODE_FILESPACE
		)
		VALUES (
			q.Alert_Config_ID,
			in_RaisedStatus_ID,
			CURRENT_TIMESTAMP,
			q.Dumpdate,
			q.BACKUP_END,
			q.BACKUP_START,
			q.CAPACITY,
			q.DELETE_OCCURED,
			q.FILESPACE_HEXNAME,
			q.FILESPACE_ID,
			q.FILESPACE_NAME,
			q.FILESPACE_TYPE,
			q.HOURS_LASTBACKUP,
			q.NODE_NAME,
			q.PCT_UTIL,
			q.SERVER_ID,
			q.UNICODE_FILESPACE
		);

	SELECT
			Wizard.AlertConfig.ALERT_ID,
			TSMALERTCONFIG.FILESPACESWITHOUTBACKUP.ID as Alert_Config_ID,
			TSM.TSMSERVER.CLIENT_ID,
			WIZARD.LOCATE_LIKE(d.NODE_NAME, tsm.FILESPACE_STATE.NODE_NAME) as INCLUSIONTYPE,
			TSM.HOURSDIFF(TSM.FILESPACE_STATE.DUMPDATE, TSM.FILESPACE_STATE.BACKUP_START) as HOURS_LASTBACKUP,

			TSM.FILESPACE_STATE.*		
	FROM	
		TSMALERTCONFIG.FILESPACESWITHOUTBACKUP
		JOIN Wizard.AlertConfig ON Wizard.AlertConfig.ID = TSMALERTCONFIG.FILESPACESWITHOUTBACKUP.ALERT_CONFIG_ID AND Wizard.AlertConfig.Active =  1 
		JOIN Wizard.Alert ON Wizard.Alert.ID = Wizard.AlertConfig.ALERT_ID AND Wizard.Alert.ACTIVE =  1 
		JOIN TSM.TSMSERVER ON TSM.TSMSERVER.CLIENT_ID = Wizard.AlertConfig.CLIENT_ID
		JOIN TSM.FILESPACE_STATE ON
			TSM.FILESPACE_STATE.SERVER_ID = TSM.TSMSERVER.ID