ADSM-L

Re: select statement

2005-03-28 11:22:46
Subject: Re: select statement
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 28 Mar 2005 09:22:31 -0700
> Is there a way that I can get all of the info. on 1
> line

This was just discussed a week or so ago. You can start dsmadmc with the
-tabdelimited or -commadelimited option to get output on a single line,
then load the resulting output into a spreadsheet or db for easy viewing.

> and also make the archive_date split into date & time?

Specify columns names like this for getting separate date & time:

select date(archive_date) as "ARCHIVE DATE", time(archive_date) as
"ARCHIVE TIME", ...

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-03-28
09:14:24:

> Hey!
>
> I am trying to put together a select statement to find all archives for
> CS-NICE-STORAGE, but it is showing me the output in the below format. Is
> there a way that I can get all of the info. on 1 line and also make the
> archive_date split into date & time?  Thanks in advance!
>
> Here is the command I was running: select
node_name,filespace_name,hl_name
> || ll_name as "File",archive_date,class_name from archives where
> node_name='CS-NICE-STORAGE'
>
>      NODE_NAME: CS-NICE-STORAGE
> FILESPACE_NAME: \\cs-nice-storage\c$
>           File: \COMPAQ
>   ARCHIVE_DATE: 1900-01-01 00:00:00.000000
>     CLASS_NAME: DEFAULT
>
>      NODE_NAME: CS-NICE-STORAGE
> FILESPACE_NAME: \\cs-nice-storage\c$
>           File: \COMPAQ
>   ARCHIVE_DATE: 1900-01-01 00:00:00.000000
>     CLASS_NAME: DEFAULT
>
>      NODE_NAME: CS-NICE-STORAGE
> FILESPACE_NAME: \\cs-nice-storage\c$
>           File: \COMPAQ
>   ARCHIVE_DATE: 1900-01-01 00:00:00.000000
>     CLASS_NAME: DEFAULT
>
>      NODE_NAME: CS-NICE-STORAGE
> FILESPACE_NAME: \\cs-nice-storage\c$
>           File: \COMPAQ
>   ARCHIVE_DATE: 1900-01-01 00:00:00.000000
>     CLASS_NAME: DEFAULT
>
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************

<Prev in Thread] Current Thread [Next in Thread>