Reports

Home > Administration > Reporting > Reports

Introduction

Reports are used to collect specific data for your reporting needs. The reports in Hornbill are point in time, meaning that the data is accurate at the point when the report is run. There are various different options with reports which will be explored in more detail in the following sections.

Reporting Types

• SQL Schema Designer

Building a report using the Hornbill SQL Schema Designer allows you to gather data using the well known SQL syntax. This option is best for users who have experience with SQL methods. The following options are available:

• Tables. The database tables that you wish to report on. For all requests, the table h_itsm_requests stores the bulk of the data. In this section it is also possible to join tables together so that you can include data friendly names in your report such as the priority name of a request.
• Select Columns. The columns from each table that you wish to include in your report.
• Filtering. Any filtering that you wish to apply to your report. This is essentially the 'WHERE' clause in a traditional SQL statement.
• Counting, Grouping & Sorting. Any grouping or sorting that you wish to apply to your report. For example if you are building a report about incidents that have a priority of either P1, P2, or P3 you may want to group the results by priority.
• Data Preview. Allows you to preview the results of the report that you have written before saving.

• An Entity

Building a report using an entity allows you to gather data based on the Hornbill entity relationships. This option is best for users that are not so comfortable in using traditional SQL methods to retrieve data.

• A Measure

Building a report using a measure allows you to base your report on data that has been collected from a measure. For more information, please see the documentation on measures.

Building A New Report - SQL Schema Designer

When building a new report using the Hornbill SQL Schema Designer, the first thing that you need to do is to select the option from the landing page of a new report configuration, but before that you must first create a new report:

• Click the button '+ Create New Report'

• Select the 'SQL Schema Designer' option from the 'Report Using' menu