Joni,

The -displaymode=table option should give you the desired format (that is
the specific purpose of this option).

Your note suggests you omitted the -ID and -PASSWORD options.

It would help if you would post (via copy & paste) the actual command you
issued along with the results, so we can see what you are seeing.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-01-19
06:54:49:

> Hello,
>
> I went out and tried the following:
>
> dsmadmc -servername=server -displaymode=table select statement and it
> didn't work.  Do you have to put the statement within single quotes?
> Thanks!
>
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************
>
>
>
>              "PAC Brion
>              Arnaud"
>              <Arnaud.Brion@PAN To
>              ALPINA.COM>               ADSM-L AT VM.MARIST DOT EDU
>              Sent by: "ADSM: cc
>              Dist Stor
>              Manager" Subject
>              <[email protected]         Re: select statement: help!
>              .EDU>
>
>
>              01/19/2005 08:16
>              AM
>
>
>              Please respond to
>              "ADSM: Dist Stor
>                  Manager"
>              <[email protected]
>                    .EDU>
>
>
>
>
>
>
> Joni,
>
> Maybe this http://msgs.adsm.org/cgi-bin/get/adsm0109/730.html will help
> you !
> Cheers.
>
>
> Arnaud
>
> ************************************************************************
> ******
> Panalpina Management Ltd., Basle, Switzerland, CIT Department
> Viadukstrasse 42, P.O. Box 4002 Basel/CH
> Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
> Direct: +41 (61) 226 19 78
> e-mail: arnaud.brion AT panalpina DOT com
> ************************************************************************
> ******
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Joni Moyer
> Sent: Wednesday, 19 January, 2005 14:00
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: select statement: help!
>
> Hey!
>
> I have one other simple question.  Is there a way that the output of
> this select statement will be able to go on one line so that it isn't so
> hard to read?  The output currently looks like this, but I would rather
> have it all fit on one line.  Thanks!
>
> NODE_NAME: VMSNW05
>       DATE: 2005-01-18
>   ACTIVITY: BACKUP
>      START: 10:31:15
>        END: 12:05:51
>  MEGABYTES: 12
>      FILES: 140
> SUCCESSFUL: NO
>
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************
>
>
>
>              "Andrew Raibeck"
>              <storman AT US DOT IBM.C
>              OM>
> To
>              Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
>              Dist Stor
> cc
>              Manager"
>              <[email protected]
> Subject
>              .EDU>                     Re: select statement: help!
>
>
>              01/18/2005 12:42
>              PM
>
>
>              Please respond to
>              "ADSM: Dist Stor
>                  Manager"
>              <[email protected]
>                    .EDU>
>
>
>
>
>
>
> Maybe something like:
>
> select entity as node_name, date(start_time) as date, cast(activity as -
> varchar(10)) as activity, time(start_time) as start, time(end_time) as
> end, -
> cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
> decimal(7,0)) as files, successful -
>         from summary -
>       where date(start_time)> date(current_timestamp - 1 day) -
>       and (entity like 'HM%' or entity like 'GEO%') -
>       order by successful
>
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
> Raibeck/Tucson/IBM@IBMUS Internet e-mail: storman AT us.ibm DOT com
>
> The only dumb question is the one that goes unasked.
> The command line is your friend.
> "Good enough" is the enemy of excellence.
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/18/2005
> 10:33:11:
>
> > Hello All!
> >
> > I have been trying, what seems like forever, to get this select
> statement
> > to work and I am just not sure what I am doing wrong... Any
> suggestions?
>  I
> > am trying to get a list of the backups of all of the servers that
> > begin with hm* and geo* within the past 24 hours and if they were
> > successful, missed or failed.  Thank you in advance!  Here is what I
> > have so far,
> but
> > it doesn't seem to work:
> >
> > select entity as node_name, date(start_time) as date, cast(activity as
> > varchar(10)) as activity, time(start_time) as start, time(end_time) as
> end,
> > cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
> > decimal(7,0)) as files, successful
> >         from summary
> >       where date(start_time) > current_timestamp - 1 day
> >       and entity like 'hm*,geo*'
> >        group by entity
> >       order by successful
> >
> > ********************************
> > Joni Moyer
> > Highmark
> > Storage Systems
> > Work:(717)302-6603
> > Fax:(717)302-5974
> > joni.moyer AT highmark DOT com
> > ********************************