====== Sandbox ======
===== Developpment =====
# 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
===== End =====
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 ====
text
text
text
text
text
text
text
text
text
text
text
text