How to redirect output of query to text file

[BobMc]

I'm wanting to have the results of a query be redirected to an txt file. I know I can run the command listed below from the admin console and it works fine. However I want to run the same command as scheduled task in my Administrative Schedules say at 7am. When I attempt this it fails saying the > is in vaild.



q vol * stgpool=archivepool > c:\archivepool.txt



Thanks in advance..



Bob

 

[heada]

I don't know if theres a way to do that within TSM, but you can use WinAT to schedule a command-line session and redirect that output to a file.



-Aaron

 

[PJ]

Haven't foud a way yet, either. I help myself with a client command schedule running the dsmadmc command. But of course id and pa show up in the script. Fortunately cl=analyst does suffice for queries.



Cheers

Peter

 

[steinweo]

You can also try this syntax: dsmadmc -id=userid -pa=passwd -out=outfile.txt <cmd>



Regards, Olivier.

 

[vkravindran]

The re-direction should work.



TSM> q vol stg=genpool > c:\vollist.txt



works for me.



Just make sure you give space on both sides of ">".



If still does not work, it may be something to do with the client version (though I don't think so).



Ravi

 

[wjacobsen]

Hello:

try: q sys -outfile=/.../my.txt

or

dsmadmc -id=sullivan -password=secret -consolemode -outfile=save.out



You might try creating a macro or script and calling it from the schedule.

Will