**See the Spotlight Statistics Repository Database blog for more information on how to query data from Spotlight repository database.
Run below query again spotlight repository.
declare @table_name NVARCHAR(255) = N'SQLCPUPercent' -- collection name, from the tablespotlight_stat_classes
declare @start_date datetime = N'2018-5-1'
declare @end_date datetime = N'2018-5-2'
declare @monitoredobject_list NVARCHAR(4000) = N'127.0.0.1_sql2014_sqlserver' -- comma-separated list of monitored instances, c.f. spotlight_monitored_objects
declare @domain_names NVARCHAR(255) -- comma-separated list of SSR domains, c.f. spotlight_domains
declare @column_names NVARCHAR(1000) -- comma separated list of columns to output, c.f. spotlight_stat_names
-- If you have several domains but only want to show a selection they would have to adjust this
select @domain_names = COALESCE(@domain_names + ',', '') + sd.domain_description
FROM [spotlight_domains] as sd
-- One could of course show less columns. This is just the most flexible way
select @column_names = COALESCE(@column_names + ',', '') + sn.statistic_name
FROM [spotlight_stat_names] as sn
join [spotlight_stat_classes] as sc
on sc.statistic_class_id = sn.statistic_class_id
where sc.statistic_class_name = @table_name
EXEC [dbo].[spotlight_rt_get_batch_data]
@start_date = @start_date,
@end_date = @end_date,
@domain_name_list = @domain_names,
@monitoredobject_list = @monitoredobject_list,
@table_name = @table_name,
@column_list = @column_names
GO
**See the Spotlight Statistics Repository Database blog for more information on how to query data from Spotlight repository database.
