SQL Query to check when collection were last updated
This SQL Query to check list all of the collections on the site server from which the query is executed.
SQL Query:-
Select CC.CollectionID,CN.CollectionName, CC.TimeUpdated
From Collection_MemberChg_Notif CC Join Collections CN on CC.CollectionID = CN.SiteID
Order By CollectionName
Output:-
