If you have a BlackBerry Enterprise server (BES) you have a configuration database that is used to manage pretty much every aspect of the server and all of your BlackBerry devices.
Periodically, I need to access this database directly to retrieve information that is not exposed via the BlackBerry Manager console. But it can take a while to work out which view or table contains the information that I am after. And sometimes the name of a column doesn’t necessarily reflect its contents. So there are plenty of test SQL queries that I need to do to suss out which pieces I need.
After checking online I could see zero references to a data dictionary for this configuration database. Even checking RIM’s own tech site yielded no clues so I called them up and asked for it directly. The tech told me this was the first time anybody had asked that question (presumably of him, not ever). He didn’t know but he checked and soon sent me the following note:
Thank you for contacting BlackBerry Customer Support.
Unfortunately the information requested is not publicly available.
Should you require further information on this subject, please don’t hesitate to contact us. Thank you again for contacting us.
BlackBerry Customer Support
Research In Motion Limited
NA Toll Free: 1-877-255-2377
UK Toll Free: 0808 100 7466
Europe: +44 1753 558400
So there you have it. If anybody knows differently I’d love to hear it, but apparently we are not to have a reference to this central resource and must continue to guess our way through our reporting.