IntelliBoard's Report Builder, known as Max, allows you, the IntelliBoard Admin (main subscriber), to build reports on your own, on the fly, answering questions to all your LMS questions.
Before you get started...
- The Report Builder functionality begins with a Level 7 IntelliBoard subscription; please review access and number of accounts here.
- The Report Builder functionality feature is only available for Main Subscribers; SubAccount/IB users do not have the ability to use the Report Builder for permission and protection of the LMS server.
- The Report Builder is comprised of two options: 1) Build by SQL or 2) Build Visually
What is Build by SQL?
Additional Details on the Build by SQL can be found here.
NOTE: Clients utilizing SQL must know how to utilize SQL code. Clients who are uncomfortable with SQL should make reports through LISA, Feature Requests or Build Visually.
Using SQL, clients will build reports in typeable field. IntelliBoard provides additional quick buttons to insert for filtering and sorting. Reports will need to be activiated inside the LMS (required permissions), and will be available through Extras > SQL Built Reports.
What is Build by MAX?
Additional Details on the Build by MAX can be found here.
Instead of using SQL, Build by MAX (Visual Report Builder) will allows clients to choose graph types and the data within the reports with a click of the button. Columns can be edited and moved using a drag and drop feature.
For additional assistance, please email helpdesk@IntelliBoard.net.
Technical Notes
IntelliBoard’s Build features, both MAX and the SQL builder rely on mapping within the IntelliBoard plugin as well as a successful connection between the LMS and the IntelliBoard account. The IntelliBoard plugin contains the required mapping allowing IntelliBoard to create a set of keys, which are then sent to the LMS as an SQL query. Mapping includes database tables and their relations (columns, aggregate functions, filters). The generated SQL runs against the Moodle databases and is then returned to IntelliBoard through the established connection.
Additional precautions for Build by SQL include:
1) SQL Injection Verification & Prohibition
IntelliBoard verifies there are no SQL queries for injections (INSERT, UPDATE, DELETE, RENAME, DROP, CREATE, TRUNCATE, ALTER, COMMI, ROLLBACK, MERGE, CALL). If there are injections, IntelliBoard prohibits the query and it will not run.
2) SQL Query Secondary Approval
The SQL builder requires a secondary activation within the Learning Management System by a Moodle Site Administrator. Without secondary approval, the SQL query remains pending and the query will not run.
Additionally, the SQL Builder may be disabled by using this variable: $CFG->intelliboardsql = false
Additional precautions for Build by MAX include:
Build by MAX utilizes pre-defined database mapping to build and run the SQL query. We use standard Moodle web services to access and allow this function.
Note: Reports built by SQL and MAX can be made available to Subaccounts/IB Users but the information will not be filtered according to the permissions.