ADSM-L

Re: Queries

1999-05-26 11:59:10
Subject: Re: Queries
From: "Richard C. Dempsey" <dempsey AT KODAK DOT COM>
Date: Wed, 26 May 1999 11:59:10 -0400
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
<Prev in Thread] Current Thread [Next in Thread>