A great way to monitor the weekly creation / volume of collections. SELECT [CollectionID] ,[SiteID] ,[CollectionName] ,[BeginDate] ,[MemberCount] ,[LocalMemberCount] ,[ResultClassName] FROM v_Collections where DateDiff(dd,v_Collections.BeginDate, GetDate ()) <= 7 and SiteID like ‘XXX%’ Sample OUTPUT
Read MoreWednesday, October 28, 2020
