'Recent MOM Alerts
'
'
'Submitted by mohan muniswamy

SUCCESS ALERT = 10

INFORMATION ALERT= 20

WARNING ALERT = 30

ERROR ALERT = 40

CRITICAL ERROR ALERT= 50

SECURITY BREACH ALERT = 60

SERVICE UNAVAILABLE ALERT = 70

 

Please let me know if the below query has any issues.

 

 

 

--***************************

Declare @SDateTime DateTime

Declare @EDateTime DateTime

Declare @Server varchar(30)

Declare @ID Varchar(1000)

--***************************

 

SET @SDateTime = '10/05/2006 12:00:00 AM'    -- Format MM/DD/YYYY 12:00:00 AM/PM

SET @EDateTime = '10/12/2006 12:00:00 AM'    -- Format MM/DD/YYYY 12:00:00 AM/PM

SET @Server = 'your Server name'   

 

 

select @ID = idComputer  from computer where name = @server

Select Name, Description, Culprit, AlertLevel, ResolutionState, RepeatCount, TimeOffirstevent, TimeofLastevent from alert WHERE (TimeOfFirstEvent BETWEEN @SDateTime AND @EDateTime) And (TimeOfLastEvent BETWEEN @SDateTime AND @EDateTime) AND idComputer=@ID and AlertLevel > 20 and ResolutionState <> 255