Systems Management

I'm assuming that you didn't see my comment on https://www.itninja.com/question/sql-statement-help yesterday (remember that you have to Follow questions to get notified of comments, etc.). 

Here is the query that I came up with:

SELECT 
COUNT(ID), DAYOFMONTH(CREATED)
FROM HD_TICKET
WHERE YEAR(CREATED) = YEAR(NOW())
AND MONTH(CREATED) - MONTH(NOW())
AND DATE(
	CASE DAYOFWEEK(LAST_DAY(NOW()))
		WHEN 1 THEN DATE_SUB(NOW(), INTERVAL 2 DAY)
		WHEN 7 THEN DATE_SUB(NOW(), INTERVAL 1 DAY)
		ELSE LAST_DAY(NOW())
	END ) = DATE(NOW())
GROUP BY dayofmonth(CREATED)

The important part is this:

AND DATE(
	CASE DAYOFWEEK(LAST_DAY(NOW()))
		WHEN 1 THEN DATE_SUB(NOW(), INTERVAL 2 DAY)
		WHEN 7 THEN DATE_SUB(NOW(), INTERVAL 1 DAY)
		ELSE LAST_DAY(NOW())
	END ) = DATE(NOW())

My logic is that

1. If the last day of the month is a Sunday (1), then the last business day was two days ago.
2. If the last day of the month is a Saturday (7) then the last business day was one day ago.
3. Otherwise the last day of the month is a weekday. 
4. If today is the last day of the month, then the entire statement is true and the query returns results, otherwise the query does not return results.

When I ran my query yesterday I got results, when I ran it today I didn't, which I took as a good sign. I have the rule set to run daily but it should only generate an email on the last day of the month. Of course, I won't know that for certain until November 29th. :)

You should be able to add the important part that is posted second to the where clause of your current rule.