none
Log parser 2.2 assistance RRS feed

  • Question

  • hi 

    Sharepoint 2010, 3 wfe and 1 application server
    Want to load IIS logs on to SQL server through Log parser 2.2

    1) Collected the IIS logs specific to a web-application from all the 3 servers and names the folder 1,2 and 3 respectively and places them in a folder called mainfolder.

    when i try to load the files i get the below 

    /////////////////////////////////////////////////////////////////////////////////////////////////////////

    C:\Program Files (x86)\Log Parser 2.2>LogParser.exe -i:iisw3c "select * INTO dbo
    .log from D:\mainfolder\*.log" -o:SQL -server:servername -database: Databasename  -createtable:ON
    Task aborted.
    Cannot open <from-entity>: Cannot find any file matching
      "D:\mainfolder\*.log"

    Statistics:
    -----------
    Elements processed: 0
    Elements output:    0
    Execution time:     0.00 seconds

     /////////////////////////////////////////////////////////////////////////////////////////////////////////

    when i point it to specific folder it works

    2) 

    C:\Program Files (x86)\Log Parser 2.2>LogParser.exe -i:iisw3c "select * INTO dbo
    .log from D:\mainfolder\1\*.log" -o:SQL -server:Databasename -database: Databasename -createtable:ON

    Statistics:
    -----------
    Elements processed: 96946
    Elements output:    96946
    Execution time:     81.43 seconds (00:01:21.43)

     /////////////////////////////////////////////////////////////////////////////////////////////////////////

    question :- what can be made so all the data from all the folders 1,2 and 3 are loaded to SQL

    Satyam


    Monday, August 1, 2016 7:27 PM

Answers

All replies