I have a query which I can run and collect all the topics which have not been marked as solved (unresolved) within the past month. Does anyone know how I can automate this to happen every week and then send the list of queries directly to an email inbox as a notification?

Maybe have a look at this: Automatically email admin report CSVs on a recurring cadence - #3 by sam

미해결 게시물을 대상으로 쿼리를 자동으로 실행하고 결과를 이메일로 보내기

pfaffman (Jay Pfaffman) 6월 7, 2023, 2:30오후 2

글		댓글	조회수
Identifying posts that haven't been resolved automatically Product Support	1	596	6월 10, 2023
Triggering alerts when topic not solved/handled/replied Feature	2	1059	8월 28, 2017
How to generate tailored email or message when problem Solved Product Support	1	409	5월 16, 2023
Automatically email admin report CSVs on a recurring cadence Feature email	10	1449	6월 8, 2023
Notify a question's author with request to choose and mark a solution Feature solved	9	4515	5월 7, 2020