Hey Everyone --
I'm trying to get some custom reporting out of Enforcer. I scanned an Oracle database and trying to generate a report with the match area so the database administrators can see easily what is a false positive and an actual hit. The Enforcer reporting features doesn't allow it to be exported.
I've started to look at the underlying Oracle tables for the protect database. I've noticed that the Message tables have what I'm looking for. I can pretty much use the MessageID or MessageComponentID as primary keys and attach everything I need. The one piece of data I can't export is the messagebody that I see on the web reporting. I'm positive it's in the MessageComponentLOB table under one of columns. It looks to be encrypted or in some kind of binary form.
Has anyone tried to do what I'm looking to complete and have any suggestions on doing it or seeing what's in the MessageComponentLOB column?