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.