This SQL Query will list all of the collections on the site server from which the query is executed on and will write the collection ID, Collection Name and the time stamp for when the collection was last updated.
SQL Query:
Select
CC.CollectionID,
CN.CollectionName,
Convert(VarChar(10), CC.TimeUpdated, 101) 'Last Updated'
From Collection_MemberChg_Notif CC
Join Collections CN on CC.CollectionID = CN.SiteID
Order By CollectionName
No Comments