Return
-
Title
How to query Spotlight Statistics Repository for Snoozed alerts? -
Description
How to query Spotlight Statistics Repository for Snoozed alerts? -
Resolution
Follow below steps to obtain Snoozed alarms information:1. Find the name of the connection alarms exist in by executing this in SpotlightStatisticsRepositoryselect * from spotlight_monitored_objects2. The data can be returned by the following stored procedure. Replace the parameters which are start date, end date and the monitored object name.exec spotlight_rep_alarms N'2015-05-01',N'2015-06-09','Aliso_sql2014_sqlserver'The snooze specific fields in the result are the Until and User fields. Until indicates how long the alarm has been snoozed for.