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