[INUG-Users] Automation Help

[trefalgar at realitybytes.net]

Looks like you're set on generic clear ...


> 3.) ACS_AC_GenericClear_Correlate_Status_Table
>      ** Condition: select * from alerts.genclr_journal_table
>                    where Resolved = 1;
>
>      ** Action: update alerts.status via '@Identifier' set Severity = 0
>                 where ACSOSGroup = 6 and LastOccurrence <= @LastOccurrence;
>
>                 insert into alerts.journal(KeyField, Serial, UID, Chrono,
> Text1) values ('@Serial:@OwnerUID:@StateChange',
>                 @Serial, @OwnerUID, getdate, 'This event has been cleared by
> the Generic Clear automation at ORLOS2');


The insert into alerts.journal should, well, insert a journal entry  
every time an event is cleared by it. Do you not see those updates?


> 4.) ACS_Expire
>      ** Condition: select * from alerts.status where ACSOSGroup = 6
>                    and ExpireTime > 0 and Severity > 0 and Acknowledged = 0;
>
>      ** Action: update alerts.status via '@Identifier' set Severity = 0
> where LastOccurrence < (getdate - @ExpireTime);


This being a two part automation has always bugged me. It would be  
faster to skip the select ...

update alerts.status set Severity = 0 where ACSOSGroup = 6 and  
ExpireTime > 0 and Severity > 0 and Acknowledge = 0 and LastOccurrence  
< (getdate - ExpireTime);

Either way, I think you should be able to check the journal box  
without having to worry about it touching every event.

Jacob