Increase SCCM data warehouse retention period

omprakash reddy 21 Reputation points
2021-07-07T15:15:01.633+00:00

Hi,

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,671 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Eswar Koneti 2,196 Reputation points
    2021-07-07T15:28:37.933+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. HanyunZhu-MSFT 1,841 Reputation points
    2021-07-08T07:02:08.777+00:00

    Hi @omprakash reddy ,

    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://learn.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.

    0 comments No comments