Billboards

Use billboards to create your own information screens for MineMarket.

Use billboard charts to create your own charts based on MineMarket data.

You can schedule billboards to run automatically, with the results saved to a file or sent via email or to a printer.

Billboard Execution Statistics

The Billboard Execution Statistics report displays one record for each combination of billboard (or chart); user who has run that billboard; and execution method (via the MineMarket Client or via a billboard schedule). Each aggregated record displays:

• The name of the billboard
• The billboard schedule name if applicable
• The user who ran the billboard
• When the record was created; that is, the first time the user ran the billboard
• The parameters with which the billboard was last run within the search date range
• The number of records returned in the billboard when it was last run within the search date range
• The start and end time of the last run within the search date range
• The difference of those two times; that is, how long it took to run the billboard
• The average time it has taken to run the billboard for that user within the search date range
• The number of times the user has run that billboard within the search date range
• Scheduling information if applicable
• Any error message applicable to the last run within the search date range

The statistics can be filtered by date range, billboard type and billboard.

A full history of individual records for each time any user has run a billboard is also available.

Billboard SQL Security

When MineMarket is installed, the billboard SQL queries are run through the primary connection to the database.

Using a primary connection to the database means that any SQL statement can be run via a billboard, effectively compromising the security of the database. To force the user to only run read-only SQL statements, a read-only user connection needs to be set up. See Create a Report Connection.