ADSM-L

adsm sql request, want data only...

2000-01-04 16:28:12
Subject: adsm sql request, want data only...
From: "Cook, Dwight E" <cookde AT BP DOT COM>
Date: Tue, 4 Jan 2000 16:28:12 -0500
I need to do a
select auditocc.node_name , auditocc.total_mb , nodes.domain_name from
adsm.auditocc , adsm.nodes where auditocc.node_name=nodes.node_name
but I need to do it across a bunch of servers so I can tack the adsm server
name and a current date on the front of each line so it will be run in
something like
for SERV in $(cat adsm_servers)
  do
  dsmadmc -serv=$SERV select blah |&
  read -p LINEIN
  while [ $? -eq 0 ]
    do
      echo date +%m/%d/%Y $SERV $LINEIN
    done
  done
so it would be nice if I could omit all the adsm connect junk & even the
column headers...
and if I do any kind of : skip the first "n" & last "y" number of records
I'm in for tons of extra work every time I upgrade any/all adsm servers...
I don't think I'm in luck but I thought I'd toss this out in case someone
does know of a way to get just that data from the select with none of the
other poop
(is there a special file number it is written to or maybe do I have the
ability to specify one ? ? ? )

later,
        Dwight
<Prev in Thread] Current Thread [Next in Thread>