Post migrations by destination, volume.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Where posts are being migrated, and how many posts have been migrated to each destination site.

Engineering

Q&A for professionals and students of engineering

SELECT 
  SUBSTRING(Comment,11,CHARINDEX('.', Comment)-11) AS [Destination Site],
  COUNT(*) AS [Number of Migrations]
FROM PostHistory
WHERE 
  PostHistoryTypeId = 35
GROUP BY 
  SUBSTRING(Comment,11,CHARINDEX('.', Comment)-11)
ORDER BY 
  COUNT(*) DESC

Enter Parameters

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