My software performs a number of jobs throughout the day and I would like to make it possible for my users to examine statistics about these jobs.
For example, the data for a job are its results (fail/pass), run duration, user name who started the job, description and an error string.
Ideally I would like to simply create a daily log file and have a 3rd party tool to analyze them. Users may want to see for instance: number of jobs create by each user, percentage of failure per day for last 7 days, etc.
Which format should I use for this (xml, csv, excel sheets)? Are there any existing tool that could analyze my files?