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:-