Package information from the Content Store database

[dougp]

Using Cognos Analytics 11.1.7

I have a need to quickly produce a list of all packages, indicating whether they currently use CQM or DQM.  I was hoping I could write a query against the Content Store database to determine the query mode, but I'm not seeing it.  Looking through the data, I also don't see any way to quickly produce the package/model xml from the Content Store.

Using a query against the Content Store database, is there a way to find the query mode and the model for a package?

If not, is there a relatively simple API for this?  I'm trying to avoid the SDK or any third-party tools.