Hi,
Is there anyway to check the SCCM data warehouse retention period and to change it to 5 years.
Hi,
Is there anyway to check the SCCM data warehouse retention period and to change it to 5 years.
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.
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.
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.
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.
16 people are following this question.