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

Executando automaticamente uma consulta para posts não resolvidos e enviando os resultados como um e-mail

pfaffman (Jay Pfaffman) Junho 7, 2023, 2:30pm 2

Tópico		Respostas	Visualizações
Identifying posts that haven't been resolved automatically Support	1	556	10 de Junho de 2023
Triggering alerts when topic not solved/handled/replied Feature	2	1018	28 de Agosto de 2017
How to generate tailored email or message when problem Solved Support	1	365	16 de Maio de 2023
Automatically email admin report CSVs on a recurring cadence Feature email	10	1280	8 de Junho de 2023
Notify a question's author with request to choose and mark a solution Feature solved	10	4396	19 de Novembro de 2023