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
|