From SSMS run below store procedure. Note: Edit @monitoredobject_list = N'my_sql2008_sqlserver' to your connection name store in table monitoredobject_list.
EXEC [dbo].[spotlight_rt_get_batch_data]
@start_date = N'2016-1-1 00:00:00',
@end_date = N'2016-7-1 00:00:00',
@monitoredobject_list = N'my_sql2008_sqlserver',
@table_name = N'deadlocklist ',
@column_list = N'victim_spid,postdate,deadlock_graph '
Blocking info:
EXEC [dbo].[spotlight_rt_get_batch_data]
@start_date = N'2016-1-1 00:00:00',
@end_date = N'2016-7-1 00:00:00',
@monitoredobject_list = N'my_sql2008_sqlserver',
@table_name = N'sqlblockinglist',
@column_list = N'waittimems,spid,resource,cpu,physicalio,program,type,command,sqluser,hostname,dbname,blocking_sql_text,ntuser,blockingosuser,blockingdatabasename,blockinghostname,blockingdbuser,blockingapplicationname,blockedbyspid'
Note: Edit @monitoredobject_list = N'my_sql2008_sqlserver' to your connection name store in table monitoredobject_list.