Active users and groups are unexpectedly deleted by the Delete Aged Discovery Data task in Configuration Manager

Applies to: Microsoft Endpoint Configuration Manager (current branch)System Center Configuration Manager (current branch - version 1906)System Center Configuration Manager (current branch - version 1902)

Symptoms


In a Configuration Manager current branch, version 1910, 1906, or 1902 environment, you use Active Directory User Discovery and Active Directory Group Discovery to discover users and groups. You also set up the Delete Aged Discovery Data task to delete aged discovery data.

In this scenario, some active users and groups are unexpectedly deleted by the Delete Aged Discovery Data task.

Cause


The Delete Aged Discovery Data task uses the sp_GetAgedDiscoveryItems stored procedure to identify aged items. Active users and groups that aren't changed within the indicated time in the task are considered to be inactive. Therefore, the task deletes the items.

Resolution


For Microsoft Endpoint Configuration Manager current branch, version 1910

This problem is fixed if you update to the globally available release of Configuration Manager current branch version 1910 from the version 1910 early update ring through the in-console update 4535819. Otherwise, follow KB 4537369 to fix the problem.

For System Center Configuration Manager current branch, version 1906 and 1902

To fix this problem, run the following TSQL query against the site database on the central administration site and primary sites.

Note Before you run the TSQL query in your production environment, we recommend that you test it in a test environment and back up your site databases.