Find Questions Migrated Without the User

0

Please login or register to vote for this query.

(click on this box to dismiss)

Use this query to find where users have their post migrated but they never followed the question to the target site.

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT
  OwnerDisplayName AS [User], PostHistory.CreationDate AS Migrated, Posts.Id AS [Post Link]
FROM
  Posts
JOIN
  PostHistory ON Posts.Id = PostHistory.PostId
WHERE
  PostHistory.PostHistoryTypeId = 36 AND
  Posts.PostTypeId = 1 AND
  OwnerUserId IS NULL
ORDER BY Posts.CreationDate DESC

Enter Parameters

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