IMPORTANT: Keep checking the MAP Blog and MAP Toolkit Survival Guide(en-US) for updates and changes , especially after new versions of MAP are released.

  1. Consolidate all the directories and subdirectories containing your server log files into a single folder (like D:\logs)

  2. Create an Excel file as a directory builder with the following values/formulas in the cells:

    A B
    1 DBName =CONCATENATE("INSERT INTO [",A1,"].[dbo].[lp_usage_log_sources]")
    2 ([log_path])
    3 VALUES
    4 START HERE =IF(LEFT(A4,2)="\\",CONCATENATE("('",A4,"')",IF(LEFT(A5,2)="\\",",","")), IF(MID(A4,2,1)=":",CONCATENATE("('",A4,"')",IF(MID(A5,2,1)=":",",","")),("GO")))
    5 copy the formula above from B5 down through B9
    6 ...
    7 ...
    8 ...
    9 ...
  3. The Excel document should look similar to this (coloring and spacing shown in image is optional):

  4. Create a text file with the directory names by typing this from a command prompt: dir /s /ad /b FilePath > C:\LogDirs.txt

  5. Open the text file and copy all the file paths

  6. Open the directory builder spreadsheet and enter your database name in the yellow box cell, overwriting "DBName" and paste your file paths, starting in the cell labeled "START HERE" in the image.

  7. Make sure you copy/paste the formula in B4 into every cell of column B that has a directory value in column A plus one more. See the image in step 8 for an example.
  8. Copy the cells starting in column B with the INSERT statement, up to and including the first GO at the end of your paths list.

  9. Open SQL Server Management Studio and expand the Databases node and find your database. Right click on the database and choose New Query. Paste the copied cells into the query editor window

  10. Execute the query
  11. Open MAP, select the Usage Tracking scenario group, click the tile corresponding to the scenario you would like to run, then "Configure Log Parsing" and confirm it contains the data you expect.