Run below query through SSMS
==============
USE [SpotlightStatisticsRepository]
declare @start datetime
declare @end datetime
set @start = dateadd(day, -30, SYSDATETIME());
set @end = SYSDATETIME();
EXEC [dbo].[spotlight_rep_alarms]
@start_date = @start,
@end_date = @end,
@monitored_object_name = N'host_instance_sqlserver'
============
You can find monitored_object_name info by select * from monitored_object_name.
For the monitored_object_name parameter the value has to be the internal name of the connection. If it is a named instance then host\instance becomes host_instance_sqlserver. A default instance because host_sqlserver.
Also change the database name in the first statement if using a non default name for the Spotlight Statistics Repository.
