====== 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