Hi Joni,
The TSM Administrator's Reference manual documents the administrative
command line interface. See the chapter "Using the Command-Line
Interface", section "Using Administrative Client Options". There are some
options available to you there that should be useful.
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-05-11
04:42:39:
> Hello All!
>
> I am trying to run the following command: select entity as "admin
> task",date(start_time) as "date",time(start_time) as
"start",time(end_time)
> as "end",cast(substr(cast(end_time-start_time as char(20)),3,8) as
char(8))
> as "duration",number,examined as
> "examined",affected,failed,cast(bytes/1024/1024 as decimal(6,0)) as
> "MB",successful from summary where start_time>=current_timestamp - 24
hours
> and activity='NAS Backup' order by entity
>
> And I received the following results when I issue a dsmadmc and output
it
> to a file. Is there a way to have this output appear on either one line
or
> have each line of output on a new line so that it will look like this:
Any
> help is appreciated!
>
> admin task: NAS_SERVER_2
> date: 2005-05-10
> start: 07:47:21
> end: 07:49:20
> duration: 00:01:59
> NUMBER: 5917
> examined: 0
> AFFECTED: 0
> FAILED: 0
> MB: 46
> SUCCESSFUL: YES
>
>
> admin task date start end duration
> NUMBER examined AFFECTED
> FAILED MB SUCCESSFUL
> ------------------ ---------- -------- -------- --------
> ----------- -------------------- --------------------
> -------------------- -------- ------------------
> NAS_SERVER_2 2005-05-10 07:47:21 07:49:20 00:01:59
> 5917 0 0
> 0 46 YES
> NAS_SERVER_2 2005-05-10 07:47:21 07:51:41 00:04:20
> 5919 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:21 07:51:46 00:04:25
> 5920 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:21 07:54:56 00:07:35
> 5918 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:22 07:51:49 00:04:27
> 5921 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:22 07:51:53 00:04:31
> 5922 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:22 08:21:12 00:33:50
> 5925 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:22 08:23:19 00:35:57
> 5923 0 0
> 0 41679 YES
> NAS_SERVER_2 2005-05-10 07:47:22 08:25:37 00:38:15
> 5924 0 0
> 0 0 YES
> NAS_SERVER_2 2005-05-10 07:47:23 08:21:16 00:33:53
> 5926 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:23 08:21:20 00:33:57
> 5927 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:23 08:32:14 00:44:51
> 5928 0 0
> 0 4020 YES
> NAS_SERVER_2 2005-05-10 07:47:23 08:41:51 00:54:28
> 5929 0 0
> 0 9553 YES
> NAS_SERVER_2 2005-05-10 07:47:23 08:54:58 01:07:35
> 5930 0 0
> 0 12239 YES
> NAS_SERVER_2 2005-05-10 07:47:24 07:53:02 00:05:38
> 5933 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:24 07:53:06 00:05:42
> 5934 0 0
> 0 0 NO
> NAS_SERVER_2 2005-05-10 07:47:24 09:09:57 01:22:33
> 5931 0 0
> 0 13764 YES
> NAS_SERVER_2 2005-05-10 07:47:24 09:15:29 01:28:05
> 5932 0 0
> 0 710 YES
> NAS_SERVER_2 2005-05-10 07:47:25 07:53:09 00:05:44
> 5936 0
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************
|