Create single CQs for all of my measurements

[Henjoe_Gutierrez]

Dear all,

I am running influxDB V1.8.3 and I have 1 database with thousands of measurements.
Each measurement’s field is sampled every seconds, I want to downsample every measurement’s field using a continuous query to another database with retention policy of “5 years”.

However, I will take much time on my side to create multiple CQs for thousands of measurements, will it be possible to create 1 CQ and that CQ will run for all existing measurements?

CREATE CONTINUOUS QUERY “cq_measurement_name” on “dbname”
BEGIN
SELECT mean(“value”) INTO “db2.measurement_name” FROM “measurement_name” GROUP BY time (1m)
END

Thank you.

Regards,
Henjoe