Is there information in the SCCM database about the date of adding a computer object to a given sccm collection? I have write the SQL Query:
select v_R_System.Name0 as MemberName, v_Collection.Name as CollectionName, v_Collection.LastMemberChangeTime, v_Collection.LastChangeTime from v_FullCollectionMembership Inner JOIN v_R_System on v_FullCollectionMembership.ResourceID = v_R_System.ResourceID Inner JOIN v_Collection on v_FullCollectionMembership.CollectionID = v_Collection.CollectionID Where v_Collection.Name like '%My SCCM Collection%'
Of course, the result concerns the modification of the collection itself, not the date of adding a computer object to this collection. Thanks for any advice, where this information is or how I can get it.