This is quite a common use-case for a self-healing service desk. Rob has definitely pointed you in the right direction of setting up a report and action schedule to achieve this.
The conditions of the report you want are probably more inline with this:
Once the report is saved, then select 'Schedule & Queue' to set up: