Re: Need to find job start, job end, calculate total job time for a group of users, TST*, for a selected date range

On Tue, Apr 25, 2017 at 4:58 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

My first thought is that it's going to be UGLY.

Right. This is not the kind of stuff SQL is built to handle well. But
it *is* the kind of stuff that many scripting languages are rather
good at.

Parsing log files has long been a bread-and-butter task for scripting,
or for even more specialized tools like awk and grep. Speaking of
which, I don't recall if Paul mentioned whether his system has the
regular expression extensions to SQL, but if it does, that might go a
long way.

This gets way, way, way easier if you bust this into several parts.

Yes. As is the case with many tricky problems. And to me, that is one
of the great things about having other tools besides SQL at your
disposal. Not to take the place of SQL, but to complement it.

John Y.