Query external SQL dB for Log Data

Question

Is it possible to query the external SQL database for audits of a specific action, even if that action is a 'sub-command' of a business rule, scheduled task etc?

Simple example would be to run a report asking - "Show me all new AD accounts created and by whom", which would return something like:-

New Account Initiator
=========== ===========
Joe Bloggs Bob Dylan
Jane Doe Bob Dylan

But may get more difficult if, for example, user accounts are deleted by a scheduled task after first being deprovisioned by a user:-

Deleted Account Initiator
============= ===========
Joe Bloggs Bob Dylan
Jane Doe Delete-Deprov-Users (Bob Dylan)

I understand this could be quite complex with the open nature of custom workflows, but interested if data is structured in the log in a manner that would allow this?

Thanks