Via the API you could get all active campaigns: API/REST/1.0/assets/campaigns?search=name=*¤tStatus=Active
I added the name= to add any prefixes you need to filter on....
Then within the campaign results you will see the CampaignEmail elements. Via those you will find all other info desired...
To get more in depth info on the email by ID you can simply use: /API/REST/1.0/assets/email/<email-id>
Personally I use some plain php script to quickly generate insights that would take me a ton of time by hand....
Hope this was of any use...
Using the API as brilliantly documented by Mr Thee is definitely one approach.
If you have access to an Analyzer account for Insight, it should be very straight forward to create a custom report for the audit.
thanks for all of the help!
As in my OP, I used Insight and the Campaign Activity by Asset subject area, but this only show's emails within campaign that have activity (opens/clicks/etc). I will give the Campaign Analysis subject area a go, but am pretty sure it yielded the same results
Thanks Mr Thee! This looks a viable option which I will definitely explore!
Try getting OBIEE report for "Email Analysis Overview" and add filter as campaign name. This will give you list of Email assets under under a particular campaign with status "Active", Using API the same can be done which I think a better option as mentioned by @Mr Thee