Skip to content

Instantly share code, notes, and snippets.

@hanleybrand
Created November 23, 2015 21:30
Show Gist options
  • Save hanleybrand/b3c944dcd7c70d8d628b to your computer and use it in GitHub Desktop.
Save hanleybrand/b3c944dcd7c70d8d628b to your computer and use it in GitHub Desktop.
Don't forget to change the date (@enddate should be the day after the range you want to count)
use WebEx
declare @startdate datetime;
declare @enddate datetime;
set @startdate = '10/1/2015'
set @enddate = '11/1/2015'
--- [TotalAttendee] > 1 (i.e. not someone seeing loggin in to an empty/unstarted meeting)
SELECT COUNT(DISTINCT [MeetingNumber]) as total_meetings_gt1
FROM [WebEx].[dbo].[RawReports]
WHERE StartDate >= @startdate and StartDate <= @enddate and [TotalAttendee] > 1
SELECT sum([TotalAttendee])as total_attend_gt1
FROM [WebEx].[dbo].[RawReports]
WHERE StartDate >= @startdate and StartDate <= @enddate and [TotalAttendee] > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment