Find tickets that are spam and write them to files

extract_spam.rb

# the tag to look for, your spam should have this tag
spam_tag = "spam"

# Where to store the eml files
# !!! Note that there is not a trailing slash, do not put one !!!
destination = "/opt/zammad/spam_tickets"

#find tickets with a spam tag
puts "Looking for Spam\r\n"
for ticket in Ticket.all do

    # If the ticket has the spam tag
    if ticket.tag_list.include?("spam")

        # Get the current time and calculate the look_back
        current_time = Time.zone.now
        look_back = current_time - 7.days

        # Make sure the email is in the needed time frame
        if ticket.created_at > look_back && ticket.created_at <= current_time

            # Tick to show work being done
            print '.'

            begin

                # Make sure the article is not nil
                if not ticket.articles.first.as_raw.nil? then

                    # Write the email to an eml file for later use
                    File.open("#{destination}/zammad_ticket_#{ticket.id}.eml", "wb") do |file|
                        file.write("#{ticket.articles.first.as_raw.content}")
                    end

                end

            rescue => e

                # Let me know if there is an error, but don't die
                puts "Error with ticket #{ticket.id}: #{e}"

            end
        end  
    end
end
puts ""
puts("Done!")