question

My9to5-2618 avatar image
0 Votes"
My9to5-2618 asked Jason-MSFT commented

What triggers MEM to remove stale/inactive devices from the DB?

Our team has been tasked with finding out what field in the DB triggers MEM to remove stale machines from the DB. From my understading, it takes 367 days for a device to be removed.

For example: v_CollectionMemberClientBaselineStatus.LastActiveTime has dates in the DB that refer to at the earliest, 9 months ago, so that leaves me to believe it is not that field.

mem-cm-general
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.

1 Answer

Jason-MSFT avatar image
1 Vote"
Jason-MSFT answered Jason-MSFT commented

From my understading, it takes 367 days for a device to be removed.

This is not correct. Only the Delete Inactive Client Discovery Data maintenance task will remove inactive devices: https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/reference-for-maintenance-tasks#delete-inactive-client-discovery-data. By default, this task deletes inactive devices after 90 days, however, also by default, this task is not enabled.

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

Thanks for your response.

So, if they do not get deleted after 367 days AND the Client Discovery Data maintenance task is not enabled, how long do they stay in the DB?

0 Votes 0 ·

Nothing happens to them.

Also, there is no 367-day counter for anything to my knowledge. Where are you getting or seeing this number at?

1 Vote 1 ·