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 3 months ago
Learn how to find content that contains dead links.
What you'll learn
- Find content with dead links
Prerequisites
- Having a CoreMedia system
Time matters
Reading time: 1 minute
Should I read this?
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?