Gather all broken links (Link-checker) in view
Normally this would involve either a custom module, or a patch to the link-checker module, with an implementation of hook_views_data. This requires some coding skills and understanding of databases.

One option is to try the Data module, which supposedly is capable of automatically deriving the required information by looking at the table structure. I've never tried it though, so whether or not it works, or how well it works, I cannot say. From looking at the modules schema, it looks like the interesting tables are:

D7 "linkchecker_block_custom", "linkchecker_comment", "linkchecker_node", "linkchecker_link"

D6 "linkchecker_boxes", "linkchecker_comments", "linkchecker_nodes", "linkchecker_links"