Log Parser 與 Log Parser Studio 介紹，快速搜尋iislog

Log Parser

"C:\LogParser\LogParser.exe" -i:iisw3c "select * into Combo.log from u_ex211001.log,u_ex211002.log,u_ex211003.log" -o:w3c

微軟官方工具
有圖形介面
官方介紹文章
https://techcommunity.microsoft.com/t5/exchange-team-blog/introducing-log-parser-studio/ba-p/601131
官方下載點在介紹文章網頁最下面很難找的地方
Image Not Showing Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
下載點直連網址
https://techcommunity.microsoft.com/gxcuf89792/attachments/gxcuf89792/Exchange/16744/1/LPSV2.D2.zip
Image Not Showing Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →

選擇Log來源
選擇增加資料夾
選隨便一個log檔
會看到標上*.log，代表這個資料夾內所有log都可以被分析
Image Not Showing Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
底下輸入區可以輸入 sql 語法
SELECT * FROM '[LOGFILEPATH]' where cs-uri-stem = '/MyPage' and cs-uri-query='Module=2'
執行搜尋請按上方紅色驚嘆號
Image Not Showing Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
第一次搜尋會提醒要選Log Type，LogParserStudio也會先偵測Log型態給予建議
File > Export > 匯出log，想跟excel相容可以選csv
Image Not Showing Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →