We are looking to generate some reports on RM'd document events. For example, number of documents viewed in a week or month etc.
Has anyone done something like this? Suggestions as to where to begin?
Audit events are stored in the LiveCycle database, so basically, you will need to design various SQL statements to pull the data that you could use in your reports.
Direct manipulation of the LC database is not supported, but the name of the table that you may want to take a look at is "edcauditentity" found in the "adobe" database schema.