Advanced Reporting Engine
Device42’s Advanced Reporting engine is a quantum leap forward in functionality. It is a fully incorporated, schedulable BI/reporting platform that lets you create both ad-hoc reports that may include visualizations, and export the output in different formats as desired. A changing selection of pre-defined reports is included with Advanced Reporting, while an unlimited number may be added under “User-Defined” reports, exported, imported, and shared!
Simply head to the Reports menu → Advanced reporting to get started:
Device42’s Advanced Reporting engine is extremely flexible, and you can use it to take your reporting to the next level, extracting insight and business intelligence from your infrastructure data.
In this section, you’ll learn how to select data and build reports in advanced reporting. If you prefer a video, see this advanced reporting blog post for a quick advanced reporting walkthrough!
Running an existing report
Running an existing report in advanced reporting is fast and easy.
Head to Reports -> Advanced Reporting and expand “Pre-defined reports” on the left by clicking the arrow to show the list of existing reports.
- Choose a report from the list, highlight it, and click the “Play” button (right-facing triangle).
- If you would like to customize an existing report, either right click or click on the hamburger menu (three horizontal lines) and choose “Duplicate” to make a copy:
- Now, double click the report you just copied, make your desired edits, and run as before!
Customizing an existing report
Customizing an existing report is easy! Simply make a copy, and edit the copy, or double click any user-created report to edit it directly.
Building a Custom Advanced Report
The following is the basic flow for building an advanced report.
- First, click the plus sign in the upper left to begin creating a new report. Choose “Advanced Report” to start.
- Give the report a simple name that identifies the report meaningfully to you.
- Move to the “Categories” tab to select the items you’d like to include in the report.
You will notice that certain categories are greyed out based on the data points you select; certain categories of data limits other items that can be included into the report to related information.
- Next, head to the “Sorts” tab to configure your sorts and to filter your data. Sorting and filtering in advanced reporting is done via SQL joins, and the advanced reporting GUI interface makes it very straightforward. Start by clicking the “Gear icon” in advanced reporting, and then select joins:
Configure any desired custom filters via the Joins window that popped up:
- Finally, configure your report layout. Select parameters you are interested from the parameter pool on the left, double clicking each to add to the report. Next, add any other fields that are relevant to your report. Now that all or fields are on the report, order them in the report.
Reporting data categories
All data categories in Advanced Reporting are inherited directly from Device42’s published database views. You can see all of them in the data dictionary, which can always be found by clicking the “data dictionary” button at the top right of the reporting window, which will show you all available categories:
Sorting and ordering data
Sorting in Advanced Reporting is handled using Joins by matching Primary and Foreign keys. Note that advanced reporting does a pretty good job attempting to set these for you, but for complicated reports, you will have to set/customize the joins yourself. You’ll want to create joins that results in the data you care about, consulting the Device42 data dictionary when necessary. Note that Primary Key’s should almost always have a matching foreign key, from being a PK matching to a FK. If you are seeing data that you didn’t expect, there may still be joins that need to be modified. Access joins by clicking the “Gear” icon, and selecting “Joins”: