select sourcedocument, sourceversion from linklists where not exists
(select * from
resources where id_ = targetdocument)Find all documents with dead links in the database
Last updated 17 minutes ago
Learn how to find content that contains dead links.
What you will learn
- Find content with dead links
Prerequisites
- Having a CoreMedia system
Target Audience
This guide is for Developers, Administrators.
Use the following SQL statement to find all documents with dead links
The next SQL statement returns all documents that have deadlinks in their latest version;
select sourcedocument, sourceversion from linklists where not exists
(select * from
resources where id_ = targetdocument) and exists (select * from
resources where id_ =
sourcedocument and latestversion_ = sourceversion)Is this page useful?