1.) The information you seek may be in part available through downloading the license records on the Adobe signing server using operatorClient.jar
2.) You could use the admin APIs (like the admin console does) to write a custom query.
3.) Or if you prefer SQL to Web API programming you could just make your own queries directly on the database.