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:
1.Enter a section title, for example OneDrive Timeline. 2.Choose the Office 365 Audit Data data source under the Audit Data data source category. 3.Choose and organization and group, if applicable. 4.Click the Timeline section type to begin editing the section. 5.Click the Select field... link under Choose event title field, and choose Display Name. 6.Click the Select field... link under Choose event description field, and choose Operation. 7.Click the Select field... link under Choose event date field, and choose Creation Time. 8.Click the Select field... link under Choose event category field. 9.In the Event category field, select Operation. 10.Click the Select field... link under Choose fields to show in detail view. 11.Expand the Microsoft Entra ID 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). 12.Group your timeline by Day, Month or Year, depending on your preference. 13.In the drop-down list labeled Choose view type, select Micro, and enable the Show legend option. 14.Click Add filter. 15.Choose Workload is equal to OneDrive. 16.Save and close your section. |
Here is a video running through these steps.
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.
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.
NOTE: Your data sources need to be a numerical value. If you are looking for a report with information about departments, locations, license names, etc., select another report type. Check out this Report Center article for more information |
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:
1.Add a title and a description, if necessary. 2.For your data source, click Entra ID Users under Users Data. 3.For select chart type, click Gauge. 4.For select operator, click Sum. 5.For choose applied to, select Meeting count (30 days) under the Teams User Activity Aggregate category. 6.Set your minimum and maximum numbers. Your maximum number in this example should be the number of Teams meetings you are targeting within your tenant within the previous month.
7.Ensure the Reverse Colors checkbox is selected. 8.Close the section. Your report should now appear as a section. |
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:
1.Add a title and a description, if necessary. 2.For your data source, click Office 365 Mail Traffic. 3.For select chart type, click Gauge. 4.For select operator, click Count. 5.For choose applied to, select Inbound Spam Content Filtered under the Office 365 Mail Traffic category. 6.Set your minimum and maximum numbers. Your maximum number in this example should be the number of spam emails your administrator deems as acceptable.
7.Ensure the Reverse Colors checkbox is not selected. 8.Close the section. Your report should now appear as a section. |
Nova has a section type called Card'. Using this feature you can include simple sum, count, maximum, minimum or average values which might add useful additional information to your reports.
For example you could show the total count of mailboxes in an organization, or the number of users in a tenant, or the total size of all mailboxes in an organization.
In this section, we will see an example of how this can be done.
9.Select an operator and an Applied to data field.
10. Add a filter group, if applicable. For example, you may want to know how many Microsoft Entra ID users have their country or reigon' parameters set to the United States.
11. Optionally, you can set analytics to 'color code' your card section. More on analytics is below.
Click save, and close the section.
NOTEs: ·The reports take a period of time to update to real time; this is usually between 24 to 48 hours. For more on this, click here. ·You can add up to 6 cards in a report. |
Analytics
The analytics tool is a quick way to see if a statistic in your environment is not as it should regularly be.
For example, you may want to immediately know the amount of spam mail coming into your tenant. You can select an operator relating to the value you want to input, for example you can have:
·greater than
·less than
·equal to
·is not equal to
then input a number. We can then apply the severity of the issue to the number applied. These include:
·OK
·Warning
·Critical
Custom card example: Teams private message count (7 days)
For example, you may want to keep an eye on the amount of Teams chats your users are sending if your environment has just adopted the Teams platform. You may also want to set a target for what you may deem acceptable. This can be achieved with the following steps:
1.Enter a card title, for example Teams Chats (7 days). 2.For the data source, select Teams User Activity Aggregate. 3.Choose your organization and organization groups, if required. 4.For operator, select Count. 5.For Applied to, select Private Chat Message Count (7 Days). 6.Under Analytics, select your Operator, Value and Severity to your needs. 7.Save and close the section. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center