You were close. Here is the report I was looking for. You may have to change the table name from dbo_tblQuarantine to tblQuarantine depending on your configuration.

SELECT DISTINCTROW Count(dbo_tblQuarantine.RejectDetails) AS CountOfRejectDetails, dbo_tblQuarantine.RejectDetails
FROM dbo_tblQuarantine
WHERE (((dbo_tblQuarantine.RejectID)=13))
GROUP BY dbo_tblQuarantine.RejectDetails
HAVING (((Count(dbo_tblQuarantine.RejectDetails)) Not Like "*Found prohibited attachment*"))
ORDER BY Count(dbo_tblQuarantine.RejectDetails) DESC;

Since that feature isn't in the program now, you could try:

SELECT        rejectdetails,
              COUNT(*) AS detailcount
FROM          tblquarantine
WHERE         rejectid=13
AND           deliver = 0)
AND           expire = 0
AND           (Left(RejectDetails,44) <> 'Found Keywords: [Found prohibited attachment')
GROUP BY      rejectdetails
ORDER BY      detailcount DESC

This will return all keywords found, with the corresponding number of times found in the quarantine database in descending order, but will exclude the 'prohibited attachment' records.

Will this get you closer to what you want?

-Ric

Thanks but let me specify better.

Whether the box "Log key words that trigger rejects" is checked or not I see no change in the logs? What does the check box do?

I have a report setup to track error code 13 and I see the keywords that trigger the rejects if the box is checked or unchecked?

So it made me wonder if there was a separate log file being created?

**** Here's my thought. IF we could track ONLY the keywords that trigger rejects then we could create a script to compare that to our keyword list. I could then see which keywords are the most effective and keep my keyword list lean and concise. That is why I requested one other time to remove Blocked Attachments from error code 13.

I know I could run a script to look for blocked keywords also but it would be cleaner to have a list that is only keywords.

That's my two cents for now. Ideas are welcomed!

Bob

When you are looking at the "Keywords filter" tab and check the box "Log key words that trigger rejects."

What log is created to track these? Where is it at?