How Do I find enabled and disabled plugins in the database?

Enabled Plugins

Plugins from the repository, once installed are stored in table PLUGINDATA. They are enabled after install.

Disabled Plugins

All Plugins (bundled and from the repository) that have been disabled have an entry in table BANDANA where BANDANAKEY is plugin.manager.state.Map.
For Example if the pagetree macro had been installed but is currently disabled would be reflected in BANDANAVALUE

<map>
  <entry>
    <string>bnpparibas.confluence.pagetree</string>
    <boolean>false</boolean>
  </entry>
</map>

It turns out that the <boolean> expression is not really evaluated. When the plugin name is present in the map it is considered as disabled