If you are managing a large ConfigMgr environment, then it is important to know when your collections updating their memberships and if your collections are updating exactly the same time, then it may hit your SQL very badly.

This script reads all the collections and you can specify which output you want – CSV or HTML.

CollectionRefreshHTML

CollectionRefreshCSV

You can download the script from here