How to find all broken internal file links in one space

[Michael Haverbier]

I want ot find all internal links of a space that are broken.

These links should have linked to a file on a page.

So to reporduce the problem:

Create a page with an attachment.

On this page link to this attachment.

Delete the attachment.

I now want to find this page (as it has a broken link in it).

[Diego]

Hello there Michael!

We have an article that aims to help Confluence Admins to Validate External links. This should help your situation as well:

• Confluence - How to Validate Links

Since the procedure deals with your database directly, it is strongly advised that you back up your database before touching it.

Let us know if the procedure above helps you out Michael!

[Michael Haverbier]

Hi there Diego,

the article suggest to find broken external link via a script which you have to run afterwards. As I want to find broken internal links, I can't do that.

But I wonder if the value prevver from the content table is some sort of value that, if null, is a hint for this link not having a file attached?

As test I put a second file link on the same page and did not delete the file afterwards. The query given in the article does not show this new link as its prevver value is not null.

So, is prevver is null the way to test for broken file links?