Advanced System Reporting

rated by 0 users
Not Answered This post has 0 verified answers | 6 Replies | 5 Followers

Top 200 Contributor
22 Posts
Lisa Stickdorn posted on 13 Apr 2011 11:29 AM

The guide states:

"It is not necessary to use Crystal Reports to run Advanced System

Reports against the statistics database. Other reporting software programs may

also be used ."

What other reporting software programs can I use?



All Replies

Top 10 Contributor
711 Posts

Hi Lisa,

There is a free building block that does reporting as well, here is some information:



Top 10 Contributor
8,717 Posts


My understanding is that the Advanced System Reporting database is just a read-only database containing a subset of data from the system, so you should be able to use whatever reporting software you like that has the capability of doing SQL queries.

ASTRO, the reporting tool building block that Eric mentioned, isn't quite the same as ASR, but it''s also very good, especially if you don't want to try and set up all your own SQL queries.



Top 100 Contributor
43 Posts

How do we query the database with our software, ie what db name, table name, credentials, etc must be used?

Top 10 Contributor
8,717 Posts


Generally speaking, the database name will be either BB_BB60 for Learn systems that were upgraded from Bb 6/7/8, or BBLEARN for those that are fresh installs.  Stats information is also copied in a stripped-down version to the BB_BB60_stats/BBLEARN_stats database.  There are dozens (hundreds?) of tables, so the table names you use will depend on exactly what information you're looking for.  The table definitions are available in the OpenDB database schema available on Behind the Blackboard.  I gave you a link in the other thread that you just posted. 

Did you install Blackboard locally, or are you hosted?  If you installed it locally, all the database credentials will be what you put in when you installed the system.


Not Ranked
1 Posts

Eric, what is the name of the free building block you mention?

Top 10 Contributor
8,717 Posts


Eric is talking about Project ASTRO (Advanced System Tracking and Reporting), which he was actually involved in initially developing.  More information is available at and .   However, it's not available on any of the public building block sites--you have to contact the developers--and unfortunately, there hasn't been much active development on it for the last several years as far as I know.


Page 1 of 1 (7 items) | RSS