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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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 > [EMAIL PROTECTED] > ********************************
