You can create reports by entering SQL queries on the report form.
If you do not know the SQL queries to use, consider using the report wizard. See Create reports using the report wizard.
1. |
Log in to the appliance System Administration Console, https://appliance_hostname/system, or select System from the drop-down list in the top-right corner of the page. Then click Reporting.
◦ |
If your appliance does not have the Organization component enabled, or if you want to access an organization-level report, log in to the appliance Administrator Console, https://appliance_hostname/admin. Or, if the Show organization menu in admin header option is enabled in the appliance General Settings, select an organization in the drop-down list in the top-right corner of the page next to the login information. Then click Reporting. |
2. |
The category of the report. If the category does not already exist, it is added to the drop-down list on the Reports page. | |||||
The query statement that generates the report data. For more information, go to the MySQL documentation at http://dev.mysql.com/doc/refman/5.0/en/. When writing a report or query against the Service Desk HD_Ticket table, be aware that the User custom field stores the user ID from the USER table in the HD_TICKET table, which is the table that holds the ticket record. If you want to display the username instead of the user ID in the report, you need to JOIN on the USER table. | |||||
|
4. |
5. |
TIP: Charts and graphs cannot be created from within the appliance reporting tool. To create charts or graphs, generate a report in XLS (Microsoft Excel) or CSV (comma-separated value) format, then import the data into a tool that has chart or graph capabilities, such as Microsoft Excel. |
You can create reports while viewing list pages, such as the Devices page.
1. |
b. |
2. |
The category of the report. If the category does not already exist, it is added to the drop-down list on the Reports page. | |
The query statement that generates the report data. For more information, go to the MySQL documentation at http://dev.mysql.com/doc/refman/5.0/en/. When writing a report or query against the Service Desk HD_Ticket table, be aware that the User custom field stores the user ID from the USER table in the HD_TICKET table, which is the table that holds the ticket record. If you want to display the username instead of the user ID in the report, you need to JOIN on the USER table. |
4. |
The report appears on the Reports page.
1. |
Log in to the appliance System Administration Console, https://appliance_hostname/system, or select System from the drop-down list in the top-right corner of the page. Then click Reporting.
◦ |
If your appliance does not have the Organization component enabled, or if you want to access an organization-level report, log in to the appliance Administrator Console, https://appliance_hostname/admin. Or, if the Show organization menu in admin header option is enabled in the appliance General Settings, select an organization in the drop-down list in the top-right corner of the page next to the login information. Then click Reporting. |
3. |
You can edit the SQL statements on single-topic reports created with the report wizard.
1. |
Log in to the appliance System Administration Console, https://appliance_hostname/system, or select System from the drop-down list in the top-right corner of the page. Then click Reporting.
◦ |
If your appliance does not have the Organization component enabled, or if you want to access an organization-level report, log in to the appliance Administrator Console, https://appliance_hostname/admin. Or, if the Show organization menu in admin header option is enabled in the appliance General Settings, select an organization in the drop-down list in the top-right corner of the page next to the login information. Then click Reporting. |
3. |
4. |
NOTE: When copying SQL statements from one type of report to another, you might have to modify the SQL statement before you can use it. For example, if you copy the SQL statement from an application compliance report, and paste it into a report that has the Aggregate Results option for organizations selected, the appliance reports errors in the SQL statement. You cannot save the report until the errors are resolved. |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center