{"id":3075,"date":"2014-11-27T09:00:08","date_gmt":"2014-11-27T09:00:08","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=3075"},"modified":"2014-11-27T09:00:08","modified_gmt":"2014-11-27T09:00:08","slug":"%e5%af%bc%e5%85%a5iis-log%e5%85%a5sqlserver","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2014\/11\/27\/%e5%af%bc%e5%85%a5iis-log%e5%85%a5sqlserver\/","title":{"rendered":"\u5bfc\u5165IIS log\u5165SQLSERVER"},"content":{"rendered":"<p>1. Download the Log Parser tool from Microsoft here. I know, it\u2019s old but works great.<\/p>\n<p>2. Dump your IIS log files somewhere (ie: c:\\temp\\logs).<\/p>\n<p>3. Run this in cmd:<\/p>\n<p>C:\\Program Files (x86)\\Log Parser 2.2>logparser \u201cSELECT * INTO iisLogs FROM c:\\temp\\logs\\*.log \u201d -i:iisw3c -o:SQL -server:localhost -database:webLogs -username:sa -password:yourpass -createTable: ON<br \/>\nif you\u2019re on 32bit, run Log Parser will be in this folder:<\/p>\n<p>C:\\Program Files\\Log Parser 2.2>logparser \u201cSELECT * INTO iisLogs FROM c:\\temp\\logs\\*.log \u201d -i:iisw3c -o:SQL -server:localhost -database:webLogs -username:sa -password:yourpass -createTable: ON<\/p>\n<p>\u6765\u81ea\uff1a<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"k9pnZY1vpk\"><p><a href=\"https:\/\/chrisbitting.com\/2012\/04\/12\/importing-iis-logs-into-a-sql-database-table\/\">Importing IIS Logs into a SQL Database \/&nbsp;Table<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Importing IIS Logs into a SQL Database \/&nbsp;Table&#8221; &#8212; Chris Bitting\" src=\"https:\/\/chrisbitting.com\/2012\/04\/12\/importing-iis-logs-into-a-sql-database-table\/embed\/#?secret=N4Mfda5yF3#?secret=k9pnZY1vpk\" data-secret=\"k9pnZY1vpk\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>\u4e0b\u8f7d\uff1alog parser:http:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=24659<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Download the Log Parser tool from Microsoft here. I  [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[],"class_list":["post-3075","post","type-post","status-publish","format-standard","hentry","category-iis"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/3075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=3075"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/3075\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=3075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=3075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=3075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}