大网数据广告活动
启动与系统组件

Set-SCDWRetentionPeriod doesn't work correctly

· 52CE 我爱测

Discusses that the Set-SCDWRetentionPeriod cmdlet doesn't set the data retention period correctly. Provides a workaround.

Applies to: System Center 2019 Service Manager (Update Rollup 2 and earlier versions)

Note: This issue has been fixed in Update Rollup 4 for System Center 2019 Service Manager.

When you run the Set-SCDWRetentionPeriod cmdlet, the cmdlet doesn't set the data retention period correctly.

Workaround

To work around this issue, run a SQL command that resembles the following example after you run the cmdlet:

-- This example sets the data retention period to 10 years for all fact tables.
 
declare @RetentionPeriodInYears int = 10
UPDATE wegi
SET wegi.RetentionPeriodInMinutes = (@RetentionPeriodInYears*366*24*60)
FROM etl.WarehouseEntityGroomingInfo AS wegi JOIN etl.WarehouseEntity AS we ON we.WarehouseEntityId = wegi.WarehouseEntityId
WHERE we.WarehouseEntityName NOT IN ('EntityManagedTypeFact', 'EntityRelatesToEntityFact')

For more information about how to set the data retention period for specific fact tables, see the following article:

How long does the Service Manager Data Warehouse retain historical data

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: Cloud-Writer). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/21/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。