Notification to Queue Owner after X amount of days - Request Unassigned

Summary:

Hi Community!

Client has a requirement to issue a notification to the Queue Owner when there are HR Help Desk requests unassigned in the queue after a certain amount of days. Has anyone implemented a groovy script for something similar or would be able to assist?

My initial thought was to write a trigger on the child Milestone object under HR Help Desk and set up notification preferences - may be possible?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

HR Help Desk Redwood

Code Snippet (add any code snippets that support your topic, if applicable):