Skip to content

Instantly share code, notes, and snippets.

@bbehrens
Last active August 29, 2015 14:00
Show Gist options
  • Save bbehrens/11270413 to your computer and use it in GitHub Desktop.
Save bbehrens/11270413 to your computer and use it in GitHub Desktop.
Sql to find attachments aws tells us are bad
select * from [file] with (nolock) where id in (select [file_id] from [attachment] with (nolock) where id in (
'b3c701da-3fc4-460f-ac53-a1930101a870',
'4721031b-c9b8-45b7-949d-a1fd017ad51f',
'75cfd34e-f930-437b-acff-a1a300e19663',
'73e904c3-84c0-4ab8-a60b-a218017aee8f',
'73c565a0-b2a8-4423-9ce7-a270014fa596',
'f85fd541-7edc-4d85-bd4a-a270014fa596',
'88df6322-c622-4b2e-a1a5-a270016a81ce',
'194ed7c4-9328-4298-bfef-a27d0180cc4c',
'f1cefb83-7188-4cf6-9a76-a2b40187e486',
'cac00538-1913-40ac-b988-a2b401878da7',
'acfee2f8-dd24-4a4b-8095-a2c00108bbcd',
'ac8c649f-a785-425a-96cd-a2c0004f03ab',
'75cfd34e-f930-437b-acff-a1a300e19663',
'a7679bc6-c25f-4b1f-b350-a27d0036c9ce',
'd953e7ba-27dd-4706-8886-a29600523552',
'f58e2b7f-58d0-4702-8317-a29600523640',
'82a005d6-014e-49c4-88ca-a2d700d60324',
'44e94a42-c882-410d-9871-a265015ae916',
'c3ab08f5-b4da-4bcd-abc8-a2490138e9f9'
))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment