AnsweredAssumed Answered

SCCM Collection in DB

Question asked by Liana on Dec 28, 2018
Latest reply on Feb 7, 2019 by Shawn.Cardamon

Hi all,

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.

thank you.

Outcomes