ADSM-L

Re: Anyone have any SQL ideas for these stats?

2001-04-25 12:50:52
Subject: Re: Anyone have any SQL ideas for these stats?
From: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
Date: Wed, 25 Apr 2001 09:51:28 -0700
Paul,

I tried:
dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.mount q act
begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8337
dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.dismount q act
begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8468

I then opened both files with Excel, set it to delimited by comma and space,
then deleted all the columns I didn't need, copied one file and pasted on
the end of the other, and sorted by drive then date/time, and came up with
the following (just an exerpt, of course).  This took about 5 minutes.

4/24/01 15:30 102200 mounted       rmt1
4/24/01 15:37 102200 dismounted    rmt1
4/24/01 20:55 100702 mounted       rmt1
4/24/01 21:17 100702 dismounted    rmt1
4/24/01 15:28 102074 mounted       rmt10
4/24/01 15:30 102074 dismounted    rmt10
4/24/01 15:37 101222 mounted       rmt11
4/24/01 15:38 101222 dismounted    rmt11

If you need to automate it, this may be doable with SQL and it'd definitely
be doable with AWK, and PERL.  Maybe SED.

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail