Nova Current - User Guide

Creating a custom table section

Tables are the best method to view a wide variety of data within one report. Unlike the other report types in the Report Center, tables allow you to view multiple fields with data that you select to suit your needs.

9.Select your data fields for your table. You can add as many fields as you require.

10. Add aggregation, sorting and filtering to your table.

11. Choose whether to enable paging. If paging is enabled, your table will be divided into multiple pages, depending on the amount of data collection for the section.

12. Choose your initial page size. This is the amount of records within each page.

You can now save your chart, and close the section.

Custom table example: Spam and malware report (30 days)

You can create an Office 365 Spam and Malware report section that shows the number of spam and malware attempts over the last 30 days. The report section includes a table showing all fields related to the Office 365 Mail Traffic data source. It is sorted in descending order by scan date, and the results are filtered so only the last 30 days display. Here is how the finished report section looks:

Click here to see how to create this report in your Nova Environment.

Here is a video of these steps.

Custom table example: License utilization

However, what if we would like a table that includes the raw data, as well as data that shows assigned, unassigned and idle units? Let us see how we do that here

Check out this video on how to create this report below.

Custom table example: Assigned licenses over time

You may want to see assigned licenses for a specific license within your environment over a certain period of time. The step by step process below explains how to do that.

See how to create this report.

Custom table example: List of users by department

This is a continuation of a report in the charts and pivots section of this guide. Below is a step by step guide on how to view your users by their associated department.

List of Users by Department

Creating a custom timeline section

Which data sources are recommended for timeline charts?

Any data source which contains time-based information can be used to create a timeline chart. The following is a list of data sources that we recommend to use for informative charts:

·Office 365 Audit Data

·Office 365 Mobiles Devices

·Detailed Message Statistics

·Microsoft Entra ID Users

·SharePoint Site Usage

Here is a diagram of the required fields for a timeline report:

9.Choose your event title, event description and event date fields. Use the diagram above to help you decide which field to select in each location.

10.Optionally, select your Event category field and any fields you would like to show in detail view.

11.Decide how you would like your timeline to look.

a.You can group your timeline by day, month or year.

b.You can view your timeline as either standard or micro.

i.Standard view presents a record in its entirety, but may not be suitable for large data sets.

ii.Micro view presents all records, but individual data sets must be hovered to be revealed.

12. Add filters if required.

13. Add an offset and/or a limit.

Individual records should now look like this:

Custom timeline example: OneDrive operations

You create a section on a report that shows OneDrive operations, color-coded per operation.  Here is how the finished report section looks:

Here are the steps to create this report section:

Here is a video running through these steps.

Creating a custom map section

Using the Map report allows you to see who has logged audit data within Nova. Has there been activity in a location which is unfamiliar to your organization? The map allows you to see if there is suspicious activity occurring in locations which your company is not associated with.

Each circle is representative of audit data being logged in that specific location, which can be viewed down to street level. The shade of the circle represents the amount of logs performed at that location.

To add the map report:

9.Add a title and description if necessary.

10.For the data source, choose Office 365 Audit Data.

11.Select your organization and organization group if necessary.

12.For select field, select Geo Location.

13.Save and close the section.

Creating a custom metric section

Using the metric report in the Report Center is a quick way to see:

·If you are reaching goals or targets that you want to reach. For example, emails being sent internally.

·If there are issues within your environment that may need investigation. For example, incoming spam email.

The gauge helps you see if you are reaching your target or limit, thus giving you insight into whether you are on course for a goal, or if you need to take action for your limits.

9.Click Gauge.

10. Select your operator and Applied to data field.

11. Add a filter group, if applicable.

12. Select your minimum and maximum ranges. For example, you can set the maximum number to an acceptable limit of spam mail being received.

13.Reverse the colors of the metric if desired.

Once you have finished, click save and close the section.

Custom metric example: How many Teams meetings did we have in the last 30 days?

This metric sections is helpful if your organization hopes to have a certain number of Teams meetings within the month. To see a gauge related to the status of your target:

Custom metric example: How many spam emails are we receiving?

Perhaps you are looking to get a clear metric on how many spam emails are coming in to your tenant, with a limit on what is acceptable. This metric gives a clear image on whether this limit is being reached. To create it: