Retriew list of msm-moved pages

[Vani1012]

we want to check all of the MSM_MOVED pages that are just sitting all over the project website

Inside each language we have so many pages and subpages, how to retriew msm_moved pages

Can anyone share the sql query

[Vaibhavi_J · Accepted solution]

Hi @Vani1012 ,

The "_msm_moved" is created when a rollout action is triggered. Using the queries you can get the result where find all pages which have to keyword.

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, '"_msm_moved"')

[Tanika02]

Hello @Vani1012 -

SQL QUERY : 

SELECT * FROM [nt:base] AS page
WHERE ISDESCENDANTNODE(page, '/content/projectwebsite')
  AND CONTAINS(page.*, '_msm_moved')