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

1
2
3
4
5
6

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