The IP address of our jira instance needed to change so the url of the external gadgets in confluence needs to be updated. I found this page
https://confluence.atlassian.com/confkb/how-to-change-urls-of-external-gadgets-296913316.html
but when I execute the SQL query the following is returned.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'body'.