Data Map the Workflow Log

OL Connect Professional
1

I’m wondering if anyone has generated a Data Map for the PlanetPress Workflow log file. I need to do some analysis and thought maybe this would be a clever way to do it. I’m specifically looking to generate a report that lets users know how many times each process runs and the duration. I think I’d just need to ignore anything that wasn’t a WPROC entry.

I have no problem taking this on from scratch, but if anyone has already invented the wheel and would like to share?

EDIT: Or split on the “dashes” line, and then throw the various WPROC, INFO etc. lines into detail tables.

2

Hello TDGreer,

If what you are looking for is only that, then you need to loop for all lines that starts with WPROC:. Each of these lines are duo, meaning that the first one is the starting and the second one the ending.
The duration is found in the second one and can be extracted using Regex.

For an experimented user as yourself, it would be a peace of cake :wink:

3

I use the following regular expressions when I need to extract some stats from Workflow logs:

This first regex allows you to extract 3 grouped values (process name, end time, elapsed time) from log entries for each end of process:

WPROC:\s([^\s]*)\s\(thread id:\s\d*\)\scomplete\s-\s(\d{2}:\d{2}:\d{2})\s\(elapsed time:\s(\d{2}:\d{2}:\d{2}:\d{3})\)

This one extracts 2 grouped values (task name, elapsed time) for all tasks inside processes:

INFO\s:\s(\d{2}:\d{2}:\d{2}.\d{3})\sPlugin\s(.*)\scompleted successfully[^(]*\(elapsed\stime:\s(\d{2}:\d{2}:\d{2}:\d{3})\)
2 Likes