KACE Product Support

Try this: - 

Select 'email@mycompany.com' AS SENDMAIL,

S.NAME AS STATUS, 

T.ID AS ID, 

T.TITLE AS ISSUE,

U.FULL_NAME AS SUBMITTER, O.FULL_NAME AS OWNER,

T.CREATED AS CREATED, T.MODIFIED AS STALLED

FROM HD_TICKET T

JOIN HD_STATUS S ON (S.ID = T.HD_STATUS_ID)

JOIN USER U ON (U.ID = T.SUBMITTER_ID)

JOIN USER O ON (O.ID = T.OWNER_ID)

WHERE (S.NAME = 'Open' AND DATEDIFF(NOW(), T.MODIFIED) >= 2)

Create a custom ticket rule with the above script. Select 'Email each recipient in query results' and put the SENDMAIL column in the field marked  'Column containing email addresses'.  Set your frequency to run hourly.