This topic applies to Managed-Hosted customers only.
Advanced System Reporting enables institutions to do robust reporting to understand how their system is being used. Data from predefined fields in a separate database is used to create and tailor reports to meet specific needs. These reports assist in understanding and analyzing use of the system and can report information such as when different types of users access the system, how they use the system, and if the system improves student performance. Librarians can discover how Content Collection items are being used, including information such as how many links exist to each item, from which courses, the frequency of access to those items and the last date of access.
Function
Data is transferred nightly into a separate reporting database. The name of the database is the name of the Virtual Installation with "stats" appended. The base Virtual Installation that appears in all implementations of Blackboard Learn, bb_bb60, has the stats database bb_bb60_stats to handle Advanced System Reporting.
The data transfer is scheduled so that it occurs at a low-traffic time of the night and is properly coordinated with Snapshot loading or other integration processes. Administrators have open access to this database so that they can develop reports to suit their institution's needs.
By default, the data transfer is scheduled to occur at 1 AM local time.
Data
The data that is transferred to the statistics database is a sub-set of the data that is located on the production database. It has a different schema from the data on the production database.
Administrators have open access to the statistics database to use for analysis and creating reports.
The following tables are transferred nightly from bb_b60 schema to the bb_bb60_stats schema:
- ACTIVITY_ACCUMULATOR
- APPLICATION
- COURSE_MAIN
- COURSE_ROLES
- COURSE_USERS
- DATA_SOURCE
- INSTITUTION_ROLES
- NAVIGATION_ITEM
- SYSTEM_ROLES
- SYSTEM_TRACKING
- USERS
- USER_ROLES
More on attribute definitions for advanced system reporting
Request access to advanced system reports
Blackboard Support can help you access advanced system reports (ASR). You will need to provide your static IP addresses so only connections from those IP addresses to the ASR Mapped IP (MIP) will be allowed. Blackboard Support will provide the following information:
- Hostname: MIP to your ASR connection
- Oracle Port: 1521
- SID: database instance name of your ASR connection
- Username: created just for your ASR connection
- Password: sent to you in a secure channel
Using this information, you can test the connectivity from your static IP address and then connect using an Oracle client.
Test connectivity
Ensure the firewall is open for your static IP.
- On Windows, select Start > Run.
- Type cmd and select OK.
- In the command line, type telnet [MIP to your ASR connection] 1521 and press Enter.
- A message appears: Connecting to [MIP to your ASR connection].
- The connection was successful if the command prompt is blank with a flashing cursor. To disconnect, press Ctrl + ].
- The connection was unsuccessful if the message Could not open connection to the host, on port 1521: Connect failed appears.
Firewall issues can prevent a successful connection. Please contact Blackboard Support for assistance.
Connect to the ASR service
Blackboard doesn't recommend any specific Oracle-compatible SQL client, as it is your preference and all work well. The following steps describe the method to connect to the ASR service using Oracle SQL Developer.
- From the ASR workstation, launch SQL developer.
The latest versions can be downloaded from the Oracle site after you create an account. Download and extract the ZIP in a folder of your choice, and create a direct access in your desktop to the executable within the extracted folder (it is not an installer).
- Select File > New.
- Select Database Tier and select OK.
- In the New Database Connection, dialog box enter the following information:
- Connection Name: a descriptive name for the connection, such as ASR Database Connection
- Username: the ASR username provided to you, typically asr_user
- Password: the ASR password provided to you
Select the Save Password checkbox if you would like to avoid having to input the password every time you connect.
- In the Oracle tab:
- Connection Type: basic
- Role: default
- Hostname: the MIP address provided to you
- Port: 1521
- SID: the Oracle SID provided to you
Don't input anything in the Access tab.
- Select Save.
- Select Test. If everything was configured correctly, you should see a Status: Success message at the bottom left corner of the dialog box.
- Select Connect or close the dialog box. In the connections sidebar, open the newly created connection.