Paste the following code into a new SQL Query window on the server that hosts your SystemCenterReporting Database:

use SystemCenterReporting

select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs

join classschemas cs

on cs.cs_classID = wcs.wcs_classID

where cs.cs_tablename = 'SC_AlertFact_Table'

and wcs.wcs_mustbegroomed = 1

select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs

join classschemas cs

on cs.cs_classID = wcs.wcs_classID

where cs.cs_tablename = 'SC_SampledNumericDataFact_Table'

and wcs.wcs_mustbegroomed = 1

select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs

join classschemas cs

on cs.cs_classID = wcs.wcs_classID

where cs.cs_tablename = 'SC_EventParameterFact_Table'

and wcs.wcs_mustbegroomed = 1

select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs

join classschemas cs

on cs.cs_classID = wcs.wcs_classID

where cs.cs_tablename = 'SC_AlertToEventFact_Table'

and wcs.wcs_mustbegroomed = 1

select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs

join classschemas cs

on cs.cs_classID = wcs.wcs_classID

where cs.cs_tablename = 'SC_EventFact_Table'

and wcs.wcs_mustbegroomed = 1

select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs

join classschemas cs

on cs.cs_classID = wcs.wcs_classID

where cs.cs_tablename = 'SC_AlertHistoryFact_Table'

and wcs.wcs_mustbegroomed = 1

To change the retention times put the following into a new query window and run it

To change to 180 days (in this example):use SystemCenterReportingexec p_updategroomdays 'SC_AlertFact_Table', 180exec p_updategroomdays 'SC_SampledNumericDataFact_Table', 180exec p_updategroomdays 'SC_EventParameterFact_Table', 180exec p_updategroomdays 'SC_AlertToEventFact_Table', 180exec p_updategroomdays 'SC_EventFact_Table', 180exec p_updategroomdays 'SC_AlertHistoryFact_Table', 180