RichardW

Hi (please forgive me if this is already on the list - although if it is I've not seen it) I would like an automated report that I c an use to accompany the files I send to our legal advisors documenting what I did to the source data and how I created the final deliverable data. I am increasingly being asked to produce an audit trail or log of what I have done with (usually) mail data. Along the lines of, "On date/time I (Richard W) indexed 20 PST files (abc.pst, def.pst, etc...), containing 20,000 mails. I filtered on any of the keywords ghi, jkl, mno, pqr. Then there were 12,000 mails. I then deduped the data and there were 4,000 mails which I exported to a production PST. There were 50 mails which failed to export first time, but worked second time." It doesn't need to be in narrative form it could be a simple list: date/time: Name of Case = Project Aardvark date/time: Case technician = Richard W date/time: Number of PST files in = 20 (abc.pst, def.pst, etc...) date/time: Number of mails indexed = 20,000 date/time: Number of keywords = 4 (ghi, jkl, mno, pqr) date/time: Boolean logic = OR date/time: Number of mails = 12,000 date/time: Number of near duplicates = 8,000 date/time: Number of mails exported = 3,950 out of 4,000 date/time: Number of mails retried = 50 out of 50 I currently do this as a manual process however I believe that all this information is already available although it is scattered within several different files in the case logs folder, case audit folder and wherever Intella Case Manager stores it data. With many thanks Richard W