• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

7. BES Administration > 84. Query the BES 4.0 Database

Query the BES 4.0 Database

Version 4.0 of the BES and the handheld added some excellent capabilities for reporting. Run reports based on model number, code version, and even applications installed on devices.

If you are the curious type and you ever looked into the schema of the BlackBerry Enterprise Server’s database before 4.0, you probably noticed something striking. The database was hardly used for anything! Before IT policies were introduced as a feature, there were only two tables in the BESMgmt database. This stands in stark contrast to what exists in the 4.0 database schema. The 4.0 database is used to a much greater degree—my installation contains no fewer than 63 tables!

Where was all this stuff stored in previous versions? In many cases, the feature that the data applies to just didn’t exist. Other types of data were stored in the BlackBerry service account mailbox in the hidden folders. With this shift to storing all data in SQL, this opens up all kinds of opportunities for running reports using this central database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint