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

Question

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

My9to5 261

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.

Accepted answer

0 additional answers

Your answer

Answer 1

Jason Sandys 31,411 Microsoft Employee Moderator

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

My9to5 261 Reputation points

2021-06-29T14:04:07.293+00:00

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?
Jason Sandys 31,411 Reputation points Microsoft Employee Moderator

2021-06-29T15:36:38.523+00:00

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?
My9to5 261 Reputation points

2021-06-29T15:47:57.567+00:00

https://learn.microsoft.com/en-us/answers/questions/154229/how-can-i-maintain-old-records-for-inventoy.html
Jason Sandys 31,411 Reputation points Microsoft Employee Moderator

2021-06-29T15:52:30.62+00:00

Ok, that's specific to inventory and not the resource itself. The resource itself (and other data associated with the resource) is not impacted by this inventory data retention and cleanup process although other data items related to the resource may have their own cleanup process and retention periods defined by other maintenance tasks.
My9to5 261 Reputation points

2021-06-29T15:56:38.2+00:00

Ok, that is good to know!

Do you know of any resources that I can look to to decipher what is kept and what isn't? This is getting confusing.
Jason Sandys 31,411 Reputation points Microsoft Employee Moderator

2021-06-29T16:00:36.913+00:00

Not to my knowledge. Reviewing the maintenance tasks should cover most of it though.

Share via

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

0 additional answers

Your answer