That would be a piece of the puzzle but we also need to know who the licenses were applied to

I am sorry I don't have access to a useful Audit Trail for this. But those things should be logged.

The two fields you will be looking at is the "Accounts/Created Trustee" and "Accounts/Modified Trustee". The columns you need are "Is user?" and "IS Read Only?".

"Is User?"  = named only user

"Is Read Only? = read only user

The hard part will be loading everything you need into Audit Trail to go back long enough to be useful (i.e. to the beginning). If your repository has been a busy one you will have quite a few audit logs in your respository. Changing your dates to include a date range that includes all of this could make your db very laaaaaaaaarge.

If this is the case, it might be useful to copy all of the older audit logs over to another machine, install sql server express on that machine along with audit trail and then use the directory you placed the logs in as the config location instead of your repository. It won't have the latest information but you can add that yourself with a normal query on your current system through the date the current audit file was created.  This way you won't hammer your production system.  

Thanks Chris. Great input!

The "Is User?" column actually doesn't have anything to do with whether or not the trustee is a named user (unfortunately); it merely distinguishes users from groups (which both come under the umbrella of "trustee" in the event type).