windows統計資料庫連接數批處理及find和findstr尋找命令使用--筆記

標籤：windows bat 批處理 find findstr

windows統計資料庫連接數批處理及find和findstr尋找命令並建立批處理bat指令碼

@echo on

set   CurDate=%date:~0,10%

set   CurTime=%time%

set   hh=%CurTime:~0,2%

if   /i   %hh%   LSS   10   ( set   hh=0%CurTime:~1,1% )

set   mm=%CurTime:~3,2%

set   ss=%CurTime:~6,2%

set   CurDateTime=%CurDate%_%hh%:%mm%:%ss%

set   CurDateTime

d:

cd \

echo =================================================================== >>mysqlccount.txt

echo 統計資料庫連接數 %CurDateTime% >>mysqlccount.txt

echo =================================================================== >>mysqlccount.txt

echo. >>mysqlccount.txt

netstat -an|findstr  /I  "10.10.10.189:3306 127.0.0.1:3306" >>mysqlccount.txt

echo. >>mysqlccount.txt

echo mysql資料庫連接數為: >>mysqlccount.txt

netstat -an|findstr  /I  "10.10.10.189:3306 127.0.0.1:3306" |find /v /c "" >>mysqlccount.txt

echo. >>mysqlccount.txt

echo -------------------------------------------------------------------- >>mysqlccount.txt

echo. >>mysqlccount.txt

netstat -an|findstr  /I  "10.10.10.189:1433" >>mysqlccount.txt

echo. >>mysqlccount.txt

echo sqserver資料庫連接數為: >>mysqlccount.txt

netstat -an|findstr  /I  "10.10.10.189:1433" |find /v /c "" >>mysqlccount.txt

echo. >>mysqlccount.txt

本文出自 “心愿” 部落格，請務必保留此出處http://xinyuan8.blog.51cto.com/677906/1615312

windows統計資料庫連接數批處理及find和findstr尋找命令使用--筆記