Ya want something like :
10YRARCH 3590DEVC 0.0 0.0 0.0 90 70
10YRARCHCP1 RMTSRV01 0.0 0.0
3590P1 3590DEVC 9,192,543.9 7.7 11.0 90 70
DISKPOOL1 DISK 71,519.0 1.2 1.2 10 0 3590P1
PR3590 3590DEVC 14,698,668.0 64.2 65.1 100 99
PRPOOL DISK 334,330.0 84.5 22.3 10 0 PR3590
VIRTTAPE RMTSRV05 2,547,593.9 0.1 0.2 90 70
these are the columns of a regular 'q stg' which are space
separated...
I did it by... (whew!)
#!/bin/ksh
dsmadmc -serv=someserv -id=xxx -pass=yyy q stg f=d | egrep '(Storage
Pool Name:|Device Class Name:|Estimated Capacity|Pct Util:|Pct
Migr:|High Mig Pct:|Low Mig Pct:|Next Storage Pool:)' | cut -d':' -f2
| paste -s -d' \n' -
exit
here is the normal stuff...
adsm> q stg
Storage Device Estimated Pct Pct High Low Next
Pool Name Class Name Capacity Util Migr Mig Mig Storage
(MB) Pct Pct Pool
----------- ---------- ---------- ----- ----- ---- --- -----------
10YRARCH 3590DEVC 0.0 0.0 0.0 90 70
10YRARCH 3590DEVC 0.0 0.0 0.0 90 70
10YRARCHCP1 RNTSRV01 0.0 0.0
3590P1 3590DEVC 9,192,543. 7.7 11.0 90 70
9
DISKPOOL1 DISK 71,519.0 1.2 1.2 10 0 3590P1
PR3590 3590DEVC 14,698,668 64.2 65.1 100 99
.0
PRPOOL DISK 334,330.0 84.5 21.6 10 0 PR3590
VIRTTAPE RMTSRV05 2,547,593. 0.1 0.2 90 70
9
______________________________ Reply Separator _________________________________
Subject: Re: Formatting of Query Outputs
Author: Steven.Chaba (Steven_Chaba AT RGE DOT COM) at unix,mime
Date: 5/3/99 12:30 PM
I tried this, no difference.
Have I angered the ADSM or SQL dieties?
Steven.
Leo Humar <lhumar AT VIC.BIGPOND.NET DOT AU> on 05/03/99 10:58:53 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: Steven Chaba/RG&E)
Subject: Re: Formatting of Query Outputs
G'day
If you send the output to a file it will be formatted on one line.
in NT the command would be "query stgpool > stgpool.txt"
Leo Humar
LCS Pty Ltd
lhumar AT vic.bigpond.net DOT au
-----Original Message-----
Fr
Fr
From: Steven Chaba <Steven_Chaba AT RGE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Date: Tuesday, May 04, 1999 12:41 AM
Subject: Formatting of Query Outputs
>(Runing server version 3.1.1.5 on AIX.)
>Here's a "pretty" question. When we do a "query stgpool", we get the
>following:
>
>ANS8000I Server command: 'query stgpool'
>
>Storage Device Estimated Pct Pct High
>Low Next
>Pool Name Class Name Capacity Util Migr Mig
>Mig Storage
> (MB) Pct
>Pct Pool
>----------- ---------- ---------- ----- ----- ----
>--- -----------
>ARCHIVEPOOL DISK 8,672.0 1.8 1.8 90
>70 ARCHIVETAP-
>EPOOL
>ARCHIVETAP- RGE 8,075,153. 0.2 0.5 90
>70
> EPOOL 9
>BACKUPPOOL DISK 43,360.0 62.7 62.7 90
>70 BACKUPTAPE-
>POOL
>BACKUPTAPE- RGE 6,044,151. 48.5 70.4 90
>70
> POOL 9
>COPYARCHIV- RGE 0.0 0.0
> EPOOL
>COPYBACKUP- RGE 7,750,533. 14.3
> POOL 0
>
>How do we get the various columns (especially the Estimated Capacity) to
>not wrap, but be displayed on a single line for better readibility? I
tried
>the "set sqldisplaymode wide" command, but it didn't seem to make any
>difference. This undesirable wrapping also is seen in the outputs of other
>commands.
>
>TIA
>Steven
>
>Steven Chaba
>ADSM Admin(-in-Training)
>Rochester Gas & Electric
>Rochester, NY USA
>716.771.2137v 771.724.8227f Steven_Chaba AT rge DOT com
|