Sharepoint activity per minute yesterday

Sharepointactivityperminuteyesterday.sql

-- Sharepoint activity per minute yesterday 
SELECT Min(logtime)              AS 'Between',
       -- Max(logtime)              AS 'Until', 
       -- CONVERT(VARCHAR(23), Min(logtime), 126) AS 'ISO8601Time',
       -- Datepart(hour, logtime) AS 'Hour',
       Count(logtime)            AS 'TotalPageViews',
       Count(DISTINCT userlogin) AS 'UniqueUsers'
FROM   [WSS_UsageApplication].[dbo].[requestusage]
WHERE  ( logtime < Dateadd(d, -0, Datediff(d, 0, Getdate())) )
       AND ( logtime > Dateadd(d, -1, Datediff(d, 0, Getdate())) )
       AND ( userlogin <> 'SHAREPOINT\system' )
       AND ( userlogin NOT LIKE '%srv_%' )
       AND ( userlogin <> '' )
       AND ( userlogin NOT LIKE '0#%' )
GROUP  BY Datepart(year, logtime),
          Datepart(month, logtime),
          Datepart(day, logtime),
          Datepart(hour, logtime),
          Datepart(minute, logtime)
ORDER  BY 'Between'