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) 2023 年 6 月 7 日午後 2:30 2

トピック		返信	表示
Identifying posts that haven't been resolved automatically Support	1	542	2023 年 6 月 10 日
Triggering alerts when topic not solved/handled/replied Feature	2	1011	2017 年 8 月 28 日
How to generate tailored email or message when problem Solved Support	1	354	2023 年 5 月 16 日
Automatically email admin report CSVs on a recurring cadence Feature email	10	1265	2023 年 6 月 8 日
Notify a question's author with request to choose and mark a solution Feature solved	10	4367	2023 年 11 月 19 日