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.
Hello,
This doesn't look applicable to Remote Desktop Manager, have you posted in the wrong forum by mistake?
Best regards,
Maurice