question

omprakashreddy-9561 avatar image
0 Votes"
omprakashreddy-9561 asked saldana-msft edited

Increase SCCM data warehouse retention period

Hi,

Is there anyway to check the SCCM data warehouse retention period and to change it to 5 years.

sql-server-generalmem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EswarKoneti-MVP avatar image
1 Vote"
EswarKoneti-MVP answered GarthJones-8673 commented

I believe the max that it can do is 3 years and the built-in tasks remove the data older than 3 years.
Not sure if you can customize this but why do you want to keep it for 5 years? Data warehouse != CMDB

Regards,
Eswar
www.eskonr.com
If the response is helpful, please click "Accept Answer" and upvote it.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the response.

The leadership wants to keep the information for much longer than 3 years (totally not sure why), that why we are looking at other options.

Can the primary SCCM SQL database hold information for 5 years if we disable all the deletion activities in site maintenance? If yes does it have any performance impact on the DB.

0 Votes 0 ·

There is no public facing task that you can disabled for this.

But there is nothing stopping you from taking copy of the db and storing as another db on the server.

0 Votes 0 ·
HanyunZhu-MSFT avatar image
0 Votes"
HanyunZhu-MSFT answered

Hi @omprakashreddy-9561 ,

Thanks for posting in Microsoft Q&A forum.

Agree with EswarKoneti, the data synchronized to the data warehouse database will be stored for three years.

In SCOM, we can change the retention period of the warehouse DB through SQL scripts. But I haven't seen MS say that it is configurable in CM.

For more details about the data warehouse service point for Configuration Manager, please view this article:
https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/data-warehouse


If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.