# cat tsm_substitutions.txt server;strict;TSMPRD1;PROD fs;strict;/root;EXCH fs;grep;/usr;SYS $DSMADMC $OPT_COMMA $OPT_DATAONLY "select o.node_name,n.DOMAIN_NAME,o.FILESPACE_NAME,o.FILESPACE_ID,o.PHYSICAL_MB,o.LOGICAL_MB,o.REPORTING_MB,f.FILESPACE_TYPE,f.CAPACITY,f.PCT_UTIL,TO_CHAR(CHAR(f.BACKUP_START),'YYYY-MM-DD HH24:MI:SS') as BACKUP_START,TO_CHAR(CHAR(f.BACKUP_END),'YYYY-MM-DD HH24:MI:SS') as BACKUP_END,TO_CHAR(CHAR(f.LAST_BACKUP_COMPLETE),'YYYY-MM-DD HH24:MI:SS') as LAST_BACKUP_COMPLETE from occupancy o,filespaces f,nodes n where o.node_name=n.node_name and o.node_name=f.node_name and o.FILESPACE_ID=f.FILESPACE_ID" | sed "s/^/$server,/" >> $tmplog/tsm_output.csv
Original Table
Year | Location |
---|---|
2004 | Athens, Greece |
2008 | Beijing, China |
2012 | London, United Kingdom |
2016 | Rio de Janeiro, Brazil |
prettytables Table
Year | Location |
---|---|
2004 | Athens, Greece |
2008 | Beijing, China |
2012 | London, United Kingdom |
2016 | Rio de Janeiro, Brazil |
tablewidth
< 100% 50px - 5em 10em 10% > | ||||
A | B | C | D | E |
---|---|---|---|---|
1 | 2 | 3 | 4 | 5 |
If there are more columns in the table than there are values in the width specification, the width willbe applied to the columns from left to right:
< 50em 20% > | |
20% | 80% |
---|---|
Specified width | The rest of the table width |
<color green>text</color> <color blue/lightgrey>text</color> <color #FF0000>text</color> <color /#FFff00>text</color> <color rgb(80%,0%,0%)/rgb(100%,80%,100%)>text</color> <color hsl(120,100%,30%):hsl(180,50%,90%)>text</color>
text text text text text text