You’ll need to do it from a shell script or similar; that type of syntax doesn’t work using the rt query language. I have some scripts that ive posted previously that are probably close to what you want. They are intended to execute from cron and email a tab separated file to you of results.
Regards
Chris Herrmann
Far Edge
+612 84251400
+614 03393309