Microsoft has several different interfaces for tools used to perform Office 365 management, reporting, and auditing tasks. In contrast, Nova users perform that work in a single user interface.
To achieve this, Nova gathers reporting and auditing data from Office 365. Reporting data is collected about every 24 hours and auditing data is received from Microsoft when it becomes available. This data is stored in Nova for as long as the organization remains a subscriber, which is much longer than Microsoft typically stores this data in Office 365.
The flexibility and power of the Nova Report Center is ideal for organizations with custom reporting needs that can't be fulfilled by the standard reports available in Nova. To create a report with the Report Center, you specify:
1.How you want the report to look. You decide what sections the report contains. Will it have charts, graphs, maps, or tables that will display the information?
2.The types of data the report will display. These are called data sources.
3.Any filters you want to apply against the data sources. For example, your data source might be a list of Office 365 users. You might want to filter that list, so your report only shows users in North America or a certain department.
Just like other Nova reports, the reports created using Report Center can be saved, scheduled, and shared. If you don't want to build an entirely new report, you could even clone an existing report and customize it to meet your new needs.
Below is an example of a report built using Report Center.
Here's more about the steps to set up a custom report:
Step 1: How will the report look?
Give a custom report structure by adding sections to control how it looks. For example, you might add these sections to a report:
·A pie chart
·A heat map
Here's where you select what section you'll add to your report:
As sections are added to a report, you're asked to define the data source information you want to display in that section. The sections control how a custom report looks and the data sources give the report substance.
You can make sections display larger or smaller on the report, or you might drag and drop a section to another location on the report.
Step 2: What is the data source?
Reports created using Report Center are just templates, or shells. The service needs data for the shell to become a useful report. Nova gathers data from a variety of services, as described earlier in this article. Then, that data is collated, filtered, and displayed in the report. Here are a few possible data sources:
·A list of Office 365 users
·A list of Office 365 distribution groups
·Data source availability
After a data source is selected, you're asked to choose which fields related to the data source will display in the report. The report's data sources control what fields display and how they interact with other data sources on the report. Here's an example of a screen where you select the fields that display in a section:
For more about data sources, go to this section.
Step 3: Do you want to filter or sort information displayed in a section?
You might add a filter to a section to show only a subset of data source information. For example, you could add a filter based on geography, so only users from a certain location display. You could add a filter that results in displaying a list of users from a specific department. Or, you could add a filter based on dates, so records older than X are filtered off the report. These are just a few examples. An organization can customize these to their specific needs.
You can also apply a sort order to a section. This is especially useful for table sections that show a list of information. For example, you can sort a list of users last name in ascending order, or you can sort that same list of users by who they report to.
These filters and sorts are saved as part of the report definition, so you'll only have to configure them once.
To filter by date, check out this article.
Report Center Terminology
The Nova Report Center has some terminology which you may not be familiar with. Check out this section for more information.
Private and Public Reports
The Private and Public report sections in the Report Center allow users to quickly see which reports are private to you and which reports are accessible by your organization.
We've got several sample reports which will help you get a feel for what can be done in the Nova Report Center.
The heatmap shows a breakdown of all of your main base licenses distributed by country. The color coding helps you identify which license has been assigned to which country the most.
To create this report:
1.Create a new section.
2.Create a title and description, if necessary.
3.For your data source, choose Office 365 Users.
4.Select your organization and organization group, if necessary.
5.For your chart type, select Heatmap.
6.For operator, select Count.
7.For applied to, select Licenses Applied to User
8.For series name, select License Set.
9.For category, select Country/Region.
10.For a filter group, choose License Set then is not empty.
11.Set your offset and limits.
12.For your drill down fields, select Company, Country/Region, Department and Display Name.
13.Your data should now appear as a heatmap. Click close section.
Here's an example of a section on a custom report you could create using the Nova Report Center.
You create a section on a report that shows OneDrive operations, color-coded per operation. Here's how the finished report section looks:
Here are the steps to create this report section:
1.Click Create Report.
2.Enter a report title, for example OneDrive Timeline.
3.Click the plus sign to add a section to the report.
4.Click the Timeline section type to begin editing the section.
5.Choose the Office 365 Audit Data data source under the Audit Data data source category.
6.Choose and organization and group, if applicable.
7.Click the Select field... link under Choose event title field
8.Expand the Office 365 Users data source, and choose Display Name.
9.Click the Select field...link under Choose event description field.
10.In the Office 365 Audit Data data source, choose Operation.
11.Click the Select field... link under Choose event date field.
12.In the Office 365 Audit Data data source, choose Creation Time.
13.Click the Select field... link under Choose event category field.
14.In the Office 365 Audit Data data source, choose Operation.
15.Click the Select field... link under Choose fields to show in detail view.
16.Expand the Office 365 Users section, and choose these 6 fields: Display Name, Department, Country/Region, Operation, Result Status, and Creation Time in this order (Other fields can be added, if required).
17.In the drop-down list labelled Choose view type, select Micro, and enable the Show legend option.
18.Click Add filter.
19.Choose Workload is equal to OneDrive.
20.Click Close section.
21.Change the timeline section's width to Full.
Here's a video running through these steps.