Any way to change the display format of the CLI?

[r.kennedy]

I've been using the CLI for years now, and the formatting of the columns and such has always

bugged me. Is there any way to change column widths and/or remove the #%@ commas from

numbers numbers larger than 1000?



It's probably just wishful thinking on my part, but I thought that I would ask.



Robert Kennedy

 

[rogwall]

is the IP address correct for that node?

compare with what is there in TSM with the actual IP add of the host/node.

 

[rogwall]

apology for posting to the wrong thread, it was supposed to be another.

 

[marcusb]

Well okay I can only think of



set sqldisplaymode wide



and starting the admin client with something like



dsmadmc -tab



Still not totally flexible but better than nothing

 

[chad_small]

The best way to format is to use SQL along with a scripting langage like PERL. Our PERL guru does some amazing stuff that TSM's SQL abilities cannot meet.

 

[Christophe_L]

 

[Christophe_L]

 

[Christophe_L]

???



On unix, I use a little ksh script "dsma" :



#!/bin/ksh

#

dsmadmc -tab -id=admin -pa=$(cat /tools/list/tsm/server2/etc/tsmadmin) -server=cltsm22 "$*" | sed -n '/ANS8000I/,/ANS8002I/p' | grep -v 'ANS800' | grep -v '^$' | tr -d ','



and I use it like this :

dsma q vol



For admin script, I use more complex script with awk, sed, ... (I wish I could use perl)



Christophe

 

[Christophe_L]

At least ! The BBCODE does not seem to work...

 

[r.kennedy]

Thanks for all the replies. After playing around for a while I've found myself using select statements and Perl'ing it for post-processing lately. Eventually I should just write a meta-shell for TSM CLI that is configurable.



Cheers