Well, to get csv, you want to go batch mode and specify the -commafy switch:
% dsmc -id=admin -password=notsosecret -comma q ev * * f=d > flat.csv
Rich
At 08:18 AM 5/26/99 -0700, you wrote:
>Joan,
>
>if you do a simple Query Event and pipe this data to a flat file, you should
>get what you want.
>
>For example: q ev * * f=d > flat.file (which gives you as a default the
>current date's events. see help q ev for more defaults and options).
>
>You could then import flat.file into Excel.
>
>Mark
>
>> ----------
>> From: Kelly, Joan B.[SMTP:joan.kelly AT CPLC DOT COM]
>> Reply To: ADSM: Dist Stor Manager
>> Sent: Wednesday, May 26, 1999 7:36AM
>> To: ADSM-L AT VM.MARIST DOT EDU
>> Subject: Queries
>>
>> Does someone know the correct query that will give me a combination of the
>> following fields:
>> Domain name, schedule name, node name, scheduled start, actual
>> start, completed times?
>> I need this csv to be able to pull into an excel worksheet.
>>
>> TIA!
>>
>
>
Richard C. Dempsey email: dempsey AT kodak DOT com
Public Online Services pager: 716-975-3539
11th Floor, Bldg 83, RL phone: 716-477-3457
Eastman Kodak Company fax: 716-722-3885
Rochester, NY 14650-2203
|