You'll want to look under the reports section in the console. In there you can create a report, pick a query as its source, save the report, then you can create a schedule for that report. The schedule can export the report as a .csv as well as a number of other formats. It can even email the reports to specific email addresses as well with some extra configuration efforts. You'll have to have an smtp email method for it. Not sure about it making a .txt file and moving it to another server. Those steps might have to be accomplished outside of the landesk tool itself. You could esaily figure that out with a task schedule though most likely.
Hope that's useful. Been a while since you posted this, so you may have already figured it out.
I would use SQL, your queries are found the the QUERY table.