Recently migrated from mediawiki to confluence 5.1 where the images did not get migrated. Need a simple way to get list of confluence pages, image name/info so that I can update/attach the confluence pages with the images. I did come across https://bobswift.atlassian.net/wiki/display/GINT/How+to+test+for+invalid+links+and+images+on+Confluence+pages but it seems that quite a fews steps are involved.
This might be a bit tricky. I was able to create this SQL query for you which will show all pages that have a image attachment.
select a.title as image_name, c.title as page_name, s.spacename as space_name, a.contenttype from attachments a join content c on a.pageid=c.contentid join spaces s on c.spaceid=s.spaceid where a.contenttype like 'image%';
This query will show the image name, page name, space name and content type. With this information you can go to the page and attach the file again :)
...ollected feedback from users around the lack of shortcuts, and we’re here to address that: In next-gen projects, I miss the keyboard shortcuts badly. This is particularly true on the Board, but also i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event