Creating Custom Reports

The Reports tool allows you to create custom reports using information from your databases. In order to utilize custom reports, you must be familiar with SQL query statements. This section gives basic instructions on creating a custom report. For details about creating custom reports, see the Custom Reports Guide.

A custom report can include information from either the Statistics database or the Enterprise database. You cannot create a custom report using tables from both.

To create a custom report

1.Click the Reports tab.

2.From the Configured Reports panel, click New.
The Create a New Report page appears.

3.Click Create a Custom Report.
The Create Reports page appears.

4.Select the database from which you would like to report and click Next.

5.Select the database table on which you would like to report, and enable the check boxes for the columns you want to include. Click Next.

6.Use the SQL keyword fields to create an SQL query statement that will return the desired information.

7.Type a Report Name in the text box and select the Output Format for the report. If you want the report to be emailed to a recipient when it is run, type the email address in the Email Report text box. Click Next.

8.Click Finish to return to the Reports page.

From the Reports page, you can run or schedule the report and view the report results.

Using Device Properties in Custom Reports

Device properties can be used to create reports containing information not listed in the standard tables, such as device serial number, OS type, or custom properties. Use PropertyName and PropertyValue to create SQL query statements for device properties.

To create a custom report for device properties

1.Click the Reports tab.

2.From the Configured Reports panel, click New.
The Create a New Report page appears.

3.Click Create a Custom Report.
The Create Reports page appears.

4.Select the database from which you would like to report and click Next.

5.From the Database Table drop-down menu, select DeviceProperty and click Next.

6.In the Select field, enter a.PropertyName, a.PropertyValue

7.In the From field, enter DeviceProperty as a

8.In the Where field, define what property you want to report by entering a.PropertyName='[Property]'

Example query:
Select: a.PropertyName, a.PropertyValue
From: DeviceProperty as a
Where: a.PropertyName='SerialNumber'

9.Click Next.

10.Enter a Report Name in the text box and select the Output Format for the report. If you want the report to be emailed to a recipient when it is run, type the email address in the email Report text box. Click Next.

11.Click Finish to return to the Reports page.

From the Reports page, you can run or schedule the report and view the report results.

If you want to report on multiple device properties, follow the same pattern, changing the letter variable. For example: Select: b.PropertyName, b.PropertyValue From: DeviceProperty as b Where: b.PropertyName='[Property]'. For more information about reporting multiple device properties, see the community document How to report multiple device properties in a custom report.