Query PublishWave Logs in Excel
You can setup an ODBC connection to your PW logs in Excel. Here are the basics steps. (I am citing Excel 2010 below...)
- Download and install the appropriate SQLite Driver here. http://www.ch-werner.de/sqliteodbc/
- In a new sheet in Excel -> Data tab -> "From Other Sources" flyout -> "From Data Connection Wizard"...select "ODBC DSN" <Next>
- SQLite3 Datasource <Next>
- Browse to the log file \\<server name>\ProgramData\Synergis\PublishWave\logs.db <OK>
- Select the table you want to place. Repeat on a new sheet for each table as desired.