Export List of Url Redirects

Jacob Mallach asked on May 2, 2023 23:35

Hello,

We are auditing redirects for our kentico site. Is there a way to retrieve a list of all url redirects (as well as the original url) set in the Kentico CMS?

Thanks for the help.

redirect

Correct Answer

Juraj Ondrus answered on May 4, 2023 07:17

In this case, the value is saved in the DocumentMenuRedirectUrl column in CMS_Document table. So, you can create a report mentioned above and use SQL query like this:

SELECT * FROM [CMS_Document] 
WHERE NULLIF(DocumentMenuRedirectUrl, '') IS NOT NULL;

And then, you can also export the report into desired format.
The above SQL query will return values for published pages only, in case you are using workflows. IF you are using workflows, the query will be bit more complicated and you will need to check the values in the CMS_VersionHistory table in the NodeXML column.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Juraj Ondrus answered on May 3, 2023 06:04

What version and hotfix are you using and where are the redirects set? There is no interface for this so it really depends on the version and where did you set the redirects. Then, based on this you can e.g. create a custom report.

0 votesVote for this answer Mark as a Correct answer

Jacob Mallach answered on May 3, 2023 20:16

We are using Kentico 12. The redirects are set through the navigation tab.

0 votesVote for this answer Mark as a Correct answer