Hi all - I am using CR2008.

Not sure if anyone has any experience with this, but I have been asked to write some Crystal Reports based on what is contained in TrackIt's "Audit Trail". I realize this is a CR forum and not a TrackIt forum, but I have googled plenty and can't seem to find anything useful.

Does anyone know how to extract and manipulate the values in the Audit Trail? Or do you know which tables I should even be pulling from the DB? (my guide skips that part, so it's possible you can't even do it at all).

I am expecting <crickets> on this one., but thanks...

I have access to all the tables (I've written many reports already). I've just never accessed the audit stuff (I don't even know if you CAN access the audit stuff). There are hundreds of tables and thousands of variables, so it would take too long to pull each one up, one-by-one and analyze them to see what they contain. I was hoping there was a TrackIt person on here that has already done this and could point me to the table(s) I need to pull. I could then figure out what to do with the data.

No luck, Lisa. We contacted the company that wrote TrackIt (Numara Software) and they said you could not access the audit trail. We have since scrapped TrackIt altogether and gone with a product called Cherwell.

But I did poke around a bit more and found that a few of the things that are in the audit trail have their own variables. For instance, if there is an "event", such as an escalation, that is tracked in the WorkOrderEventType. Couldn't find much more than that though. Sorry!