Batch Scripting output format in table format -


i have created batch script below, , using balt utility send output on email.

set length=0   /f "tokens=1 delims=/" %%t in ("%date%") set tt=%%t  /f "tokens=2 delims=/" %%a in ("%date%") set da=%%a  /f "tokens=3 delims=/" %%b in ("%date%") set db=%%b  /f "tokens=4 delims=/" %%c in ("%date%") set dc=%%c  /f "tokens=1 delims=: " %%i in ('time /t') set dd=%%i  /f "tokens=2 delims=: " %%j in ('time /t') set de=%%j  /f "tokens=3 delims=: " %%k in ('time /t') set df=%%k   c:  cd \siebserver\siebsrvr\bin   srvrmgr /g mt-wi-sblgatew:2320 /e siebelpro /u sadmin /p sadm1npw /i "c:\ujj\comm.cfg"   ren status.csv status_old.csv findstr /v /r /c:["srvrmgr"]["list"] status_old.csv > status.csv  copy status.csv "c:\ujj\status.txt del status.csv  exit

but output looks below:

sv_name    cc_alias                   cp_num_run_tasks  cp_max_tasks  cp_actv_mts_procs  cp_max_mts_procs  cp_disp_run_state   ---------  -------------------------  ----------------  ------------  -----------------  ----------------  -----------------   sblprod01  ecommunicationsobjmgr_enu  11                100           4                  4                 running             sblprod02  ecommunicationsobjmgr_enu  9                 100           4                  4                 running             sblprod04  ecommunicationsobjmgr_enu  8                 100           4                  4                 running             sblprod03  ecommunicationsobjmgr_enu  16                100           4                  4                 running              4 rows returned.   sv_name    cc_alias       cp_num_run_tasks  cp_max_tasks  cp_actv_mts_procs  cp_max_mts_procs  cp_disp_run_state   ---------  -------------  ----------------  ------------  -----------------  ----------------  -----------------   sblprod02  eaiobjmgr_enu  75                200           8                  8                 running             sblprod03  eaiobjmgr_enu  71                200           8                  8                 running             sblprod01  eaiobjmgr_enu  90                200           8                  8                 running             sblprod04  eaiobjmgr_enu  73                200           8                  8                 running              4 rows returned.  srvrmgr> spool off spool off

how can make output in table format.

if want actual .csv file commas instead of tabs , spaces code should work. more realiable way of obtaining date information added well.

@echo off setlocal enabledelayedexpansion set length=0  :: obtaining date information /f "tokens=2 delims==+-" %%i in ('wmic os localdatetime /value ^| findstr "="') (     set _date=%%i     set yyyy=!_date:~0,4!     set mm=!_date:~4,2!     set dd=!_date:~6,2!     set hh=!_date:~8,2!     set min=!_date:~10,2!     set sec=!_date:~12,2!     set mili=!_date:~-6! )  cd \siebserver\siebsrvr\bin  srvrmgr /g mt-wi-sblgatew:2320 /e siebelpro /u sadmin /p sadm1npw /i "c:\ujj\comm.cfg"   ren status.csv status_old.csv findstr /v /r /c:["srvrmgr"]["list"] status_old.csv > status.csv  ::replacing tabs , spaces commas obtain actual .csv file set "output=" if exist status_mod.csv del status_mod.csv /f "tokens=* delims=" %%i in ('findstr "_" status.csv') (     %%j in (%%i) (         set "output=!output!%%j,"     )     echo !output:~0,-1! >> status_mod.csv     set "output=" )  copy /y status_mod.csv "c:\ujj\status.txt" del status_mod.csv

Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more