question

My9to5-2618 avatar image
0 Votes"
My9to5-2618 asked saldana-msft edited

Is it possible to extend the Data Warehouse data retention to greater than 3 years?

https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/data-warehouse

Data synchronized to the data warehouse database is kept for three years. Periodically, a built-in task removes data that's older than three years.


Is there any way to adjust the built in task?

mem-cm-generalmem-cm-site-deployment
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.

GarthJones-8673 avatar image
0 Votes"
GarthJones-8673 answered

I don't see one within my environment.

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.

HanyunZhu-MSFT avatar image
0 Votes"
HanyunZhu-MSFT answered My9to5-2618 commented

Hi,

The reference article you viewed is right.
In SCOM, we can adjust the retention period of the warehouse DB through SQL scripts.
But I haven't seen MS saying that it can be configured in ConfigMgr.


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.

· 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.

Hi @My9to5-2618 , Hope things are going well. I am writing to see if there's any update on our issue. If you need any further assistance, feel free to let us know.

0 Votes 0 ·

Sorry for the late reply. We have not found anything

0 Votes 0 ·