
【已解決】緊急求助批處理IIS日志多文件處理萬分感謝最后由 shniutan 于 -5-5 08:43非常感謝idwma,qixiaobin0715,xczxczxcz 三位大神的無私幫助,謝謝你們!有3個IIS日志文件,如下:a.txt//每行包含1個infoID,各不相同-1-2 08:00:01 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 -1-2 08:00:06 192.168.1.10 post filedetail.aspxinfoid=1q1w3e4r-6y2u8i 80 -1-2 08:00:11 192.168.1.10 post filedetail.aspxinfoid=1q2w4e4r-6y3u8i 80 -1-2 08:00:16 192.168.1.10 post filedetail.aspxinfoid=1q3w3e4r-6y4u8i 80 -1-2 08:00:21 192.168.1.10 post filedetail.aspxinfoid=1q4w3e4r-6y5u8i 80 -1-2 08:00:26 192.168.1.10 post filedetail.aspxinfoid=1q5w3e4r-6y6u8i 80 -1-2 08:00:31 192.168.1.10 post filedetail.aspxinfoid=1q6w3e4r-6y7u8i 80 -1-2 08:00:36 192.168.1.10 post filedetail.aspxinfoid=1q7w3e4r-6y8u8i 80 -1-2 08:00:41 192.168.1.10 post filedetail.aspxinfoid=1q8w3e4r-6y9u8i 80 -1-2 08:00:46 192.168.1.10 post filedetail.aspxinfoid=2q2w3e4r-6y1u8i 80 b.txt//每行包含用戶名、IP地址,有用戶名、IP地址均重復的行-1-2 08:00:05 192.168.1.10 get bbslogin.aspxusername=張三&password=6y1u8i 80 - 192.168.1.21 200 0 0-1-2 08:00:15 192.168.1.10 get bbslogin.aspxusername=李四關&password=6y1u8i 80 - 192.168.1.23 200 0 0-1-2 08:00:25 192.168.1.10 get bbslogin.aspxusername=王五&password=6y1u8i 80 - 192.168.1.25 200 0 0-1-2 08:00:35 192.168.1.10 get bbslogin.aspxusername=孫六&password=6y1u8i 80 - 192.168.1.27 200 0 0-1-2 08:00:45 192.168.1.10 get bbslogin.aspxusername=劉七地&password=6y1u8i 80 - 192.168.1.29 200 0 0-1-2 08:00:55 192.168.1.10 get bbslogin.aspxusername=楊八貓&password=6y1u8i 80 - 192.168.1.31 200 0 0-1-2 08:01:05 192.168.1.10 get bbslogin.aspxusername=江九&password=6y1u8i 80 - 192.168.1.33 200 0 0-1-2 08:03:25 192.168.1.10 get bbslogin.aspxusername=周十&password=6y1u8i 80 - 192.168.1.35 200 0 0-1-2 08:03:45 192.168.1.10 get bbslogin.aspxusername=巴一巴&password=6y1u8i 80 - 192.168.1.37 200 0 0-1-2 08:04:25 192.168.1.10 get bbslogin.aspxusername=趙二&password=6y1u8i 80 - 192.168.1.39 200 0 0-1-2 09:00:25 192.168.1.10 get bbslogin.aspxusername=王五&password=6y1u8i 80 - 192.168.1.25 200 0 0-1-2 09:00:35 192.168.1.10 get bbslogin.aspxusername=孫六&password=6y1u8i 80 - 192.168.1.27 200 0 0-1-2 09:00:45 192.168.1.10 get bbslogin.aspxusername=劉七地&password=6y1u8i 80 - 192.168.1.29 200 0 0-1-2 09:00:55 192.168.1.10 get bbslogin.aspxusername=楊八貓&password=6y1u8i 80 - 192.168.1.31 200 0 0c.txt//每行包含文件ID、IP地址,存在同一個IP訪問不同文件ID的情況,也存在不同IP訪問同一文件的情況-1-2 08:00:01 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.21 200 0 0-1-2 08:00:02 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.23 200 0 0-1-2 08:00:03 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.25 200 0 0-1-2 08:00:04 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.27 200 0 0-1-2 08:00:06 192.168.1.10 post filedetail.aspxinfoid=1q1w3e4r-6y2u8i 80 - 192.168.1.23 200 0 0-1-2 08:00:11 192.168.1.10 post filedetail.aspxinfoid=1q2w4e4r-6y3u8i 80 - 192.168.1.21 200 0 0-1-2 08:00:16 192.168.1.10 post filedetail.aspxinfoid=1q3w3e4r-6y4u8i 80 - 192.168.1.29 200 0 0-1-2 08:00:21 192.168.1.10 post filedetail.aspxinfoid=1q4w3e4r-6y5u8i 80 - 192.168.1.23 200 0 0-1-2 08:00:26 192.168.1.10 post filedetail.aspxinfoid=1q5w3e4r-6y6u8i 80 - 192.168.1.27 200 0 0-1-2 08:00:31 192.168.1.10 post filedetail.aspxinfoid=1q6w3e4r-6y7u8i 80 - 192.168.1.29 200 0 0-1-2 08:00:36 192.168.1.10 post filedetail.aspxinfoid=1q7w3e4r-6y8u8i 80 - 192.168.1.33 200 0 0-1-2 08:00:41 192.168.1.10 post filedetail.aspxinfoid=1q8w3e4r-6y9u8i 80 - 192.168.1.35 200 0 0-1-2 08:00:46 192.168.1.10 post filedetail.aspxinfoid=2q2w3e4r-6y1u8i 80 - 192.168.1.33 200 0 0-1-2 08:00:51 192.168.1.10 post filedetail.aspxinfoid=3q2w3e4r-6y1u8i 80 - 192.168.1.37 200 0 0-1-2 08:00:56 192.168.1.10 post filedetail.aspxinfoid=4q2w3e4r-6y7u8i 80 - 192.168.1.35 200 0 0-1-2 08:01:16 192.168.1.10 post filedetail.aspxinfoid=6q2w3e4r-6y7u8i 80 - 192.168.1.29 200 0 0-1-2 08:01:51 192.168.1.10 post filedetail.aspxinfoid=5q2w3e4r-6y7u8i 80 - 192.168.1.27 200 0 0-1-2 08:01:56 192.168.1.10 post filedetail.aspxinfoid=6q2w3e4r-6y7u8i 80 - 192.168.1.25 200 0 0-1-2 08:01:26 192.168.1.10 post filedetail.aspxinfoid=6q2w3e4r-6y7u8i 80 - 192.168.1.21 200 0 0-1-2 08:01:36 192.168.1.10 post filedetail.aspxinfoid=6q2w3e4r-6y7u8i 80 - 192.168.1.23 200 0 0-1-2 08:01:46 192.168.1.10 post filedetail.aspxinfoid=6q2w3e4r-6y7u8i 80 - 192.168.1.25 200 0 0-1-2 08:02:21 192.168.1.10 post filedetail.aspxinfoid=7q2w3e4r-6y7u8i 80 - 192.168.1.33 200 0 0-1-2 08:03:36 192.168.1.10 post filedetail.aspxinfoid=8q2w3e4r-6y7u8i 80 - 192.168.1.29 200 0 0-1-2 08:10:36 192.168.1.10 post filedetail.aspxinfoid=1q7w3e4r-6y8u8i 80 - 192.168.1.31 200 0 0-1-2 08:20:36 192.168.1.10 post filedetail.aspxinfoid=1q7w3e4r-6y8u8i 80 - 192.168.1.31 200 0 0-1-2 08:30:36 192.168.1.10 post filedetail.aspxinfoid=1q7w3e4r-6y8u8i 80 - 192.168.1.31 200 0 0-1-2 08:33:46 192.168.1.10 post filedetail.aspxinfoid=2q2w3e4r-6y1u8i 80 - 192.168.1.33 200 0 0-1-2 08:34:21 192.168.1.10 post filedetail.aspxinfoid=1q4w3e4r-6y5u8i 80 - 192.168.1.23 200 0 0-1-2 08:34:26 192.168.1.10 post filedetail.aspxinfoid=1q5w3e4r-6y6u8i 80 - 192.168.1.27 200 0 0-1-2 08:40:01 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.21 200 0 0-1-2 08:40:02 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.23 200 0 0-1-2 08:40:03 192.168.1.10 post filedetail.aspxinfoid=1q2w3e4r-6y1u8i 80 - 192.168.1.25 200 0 0希望能用批處理實現:1.刪除b.txt中用戶名、IP地址均重復的行,輸出結果到d.txt。2.從c.txt中找出a.txt中每個infoID的被訪問情況,分別輸出到e1.txt、e2.txt、……中,再根據d.txt中用戶名和IP地址的對應關系,統計出e1.txt、e2.txt、……中每個IP地址對應用戶的訪問次數,分別輸出infoid、IP地址、用戶名、訪問次數信息到f1.txt、f2.txt、……中。3.查找f1.txt、f2.txt、……所有文件中infoid被同一用戶訪問超過2次的記錄,匯總輸出到新的文件中,每個用戶1個文件,輸出信息包括IP地址、用戶名、infoid、訪問次數。萬分感謝!

