Users by # of moderation badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

Q&A for SharePoint enthusiasts

WITH b AS (SELECT UserId, Name
  FROM Badges
  WHERE Name IN ('Civic Duty', 'Cleanup', 'Deputy', 'Electorate', 'Marshal', 'Reviewer', 'Sportsmanship', 'Steward')
  GROUP BY UserId, Name)
SELECT UserId AS [User Link], COUNT(*) AS 'Number of moderation badges'
  FROM b
  GROUP BY UserId
  ORDER BY COUNT(*) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results