Log Parser Lizard GUI (free edition) - Lizard Labs

Using Lizard to parse PPS Planning logs.

1. Create a header file.

DateTime Event PPS Location User Details

Note that spaces delimit the file.

2.  Create a new Log Parser Lizard Group & Query for PPS.

3. Select Tab-separated and space-separated values

4. Enter Query

select top 100 *
from '\\Path_To_PPS_Server_Logs\trace log\server.log'
--where details like '%error%'
order by rownumber desc

5. In Query Properties:

iHeaderFile = <step 2 filename>
nFields = 6
iSeparator = ‘space’
FixedSep = true

Save and “Generate” (run) the query.

 

Log Parser Lizard GUI (free edition) - Lizard Labs