Azure-DevOps Questions by Month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

declare @pStartDate date = '##StartDate##'
declare @pEndDate date = '##EndDate##'

SELECT 

    CAST(
       CAST(DATEPART(YEAR, CreationDate) AS varchar) + 
       '-' + 
       CAST(DATEPART(MONTH, CreationDate) AS varchar) + 
       '-01'  
     AS DATETIME),
  COUNT(*) [Total Questions]
FROM Posts p
  LEFT JOIN PostTags pt ON p.Id = pt.PostId
  LEFT JOIN Tags t ON t.id = pt.TagId
  LEFT JOIN PostTypes pty ON pty.Id = p.PostTypeId
  WHERE t.TagName = 'azure' AND pty.Name = 'Question' and 
        p.creationdate between @pStartDate and @pEndDate
        --and p.AnswerCount = 0 --remove this line to get total tagged questions
GROUP BY 
  DATEPART(YEAR, CreationDate), 
  DATEPART(MONTH, CreationDate)
ORDER BY 
  DATEPART(YEAR, CreationDate) DESC, 
  DATEPART(MONTH, CreationDate) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results