By AG, this is relatively straightforward. By Application... This is a nightmare.
-JD.
If this was AG, it would have already been done.
I'm probably going to take a dump of ALL 87's from the system log for a particular application load, throw it into excel...
Then look at log entries for "deletes", throw them into excel...
I've found it quite easy to gather metrics and info this way. It sure beats having to have my operations team run queries in prod, especially since I'm the only one that knows the relationships of the tables.