SQL Query : Collections created in last 7 days

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

Related posts

Leave a Comment