I would like to clean up the Attachment folder on our server - I know there are a good amount I do not use or removed from a test case.
What is the best/safest way to do this? I see 2 possibilities:
Compare the file names in the Attachment folder on the server (we are self hosted and currently the folder is on the C drive (I plan to work with our team to change it to a network folder) with the files in the Attachment table OR
Query the Attachment table where the case_id and test_change_id are both NULL and all records returned are not used by any case…
I am going to assume that #2 is probably the best way if I understand the way the system uses the table.