Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Quadrotech Nova Current - User Guide

Adoption Accelerator Delegation & Policy Control Reporting Tenant Management System Settings About

Connecting to Office 365 using Powershell

Another great management option for Office 365 is to use PowerShell, a command line interface that connects to Office 365 via the Internet.

Whilst it may seem daunting to people unfamiliar with working on the Command Line, it is simpler than it seems. This blog post will guide you through the basics of connecting to PowerShell.

Set up your computer to use Office 365 PowerShell

Firstly, you need to set up your computer with the necessary PowerShell modules. This only needs to be done once, however you need to have administrative permissions on the computer. Unfortunately, Microsoft has made this part very confusing, as there are multiple versions of the PowerShell module available.


The newest version is known as the Azure AD PowerShell module and is distributed via the PowerShell Gallery. This unfortunately means that you cannot download the module directly. Instead, you will need to use the PowerShellGet module, which might not be available on your system. In this case, you will have to install the module by using one of the methods detailed in this article.


An older version of the module, known as the Windows Azure Active Directory PowerShell or MSOnline module is also available. Like the Azure AD module, it is also being distributed via the PowerShell Gallery, however an MSI installer version can be downloaded from here.


Both the Azure AD and MSOnline modules also have a Preview version, further contributing to the confusion. What is even worse, some functionalities are only available in specific module versions, thus it might be necessary to have multiple versions installed and to use them interchangeably.


Connecting PowerShell to Office 365

Regardless of which version of the module you install, connecting to Office 365 is performed by executing a cmdlet. To connect via the Azure AD module, use:




To connect via the older MSOnline module, use:




You will be prompted for credentials. Enter the full UPN (User principal name) value of your Office 365 administrator account as well as your password. Depending on the settings you have configured, you might be asked to perform additional verification via Azure MFA.


Connecting PowerShell to Exchange Online

To connect PowerShell to Exchange Online, you will need to configure the execution policy to allow execution of signed PowerShell script. You can find detailed steps in this article. You need to perform them only once on each machine you will be connecting fromOnce the execution policy is configured, you need to create a connection to Office 365. You can do this by typing (or copying/pasting) the following into PowerShell.



NOTE: To paste into PowerShell you use Right Click. Here is a video on how to use Copy and Paste in PowerShell.


$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential (Get-Credential) -Authentication Basic -AllowRedirection

Once this is in the PowerShell window, press Enter to execute the command.


Now you simply type in the username and password for an Administrator account in your Office 365 and click OK. You may see some warnings, but they are part of the process.


You are now authenticated into Office 365 and have a session open. The last step is to fetch all the available cmdlets by using the following PowerShell command:


Import-PSSession $session


You should now be connected.




Now you have gone to all the trouble of connecting to PowerShell, you should run a task to prove that it works. Type the following into the PowerShell window and press Enter:




You should now see a list of all the users in your Office 365 account that have mailboxes.


Configuring Nova for SharePoint Online reporting

This section will explain the process you will need to follow in order to setup Nova for SharePoint Online reports. The process will take you through granting the existing Nova Reporting service account permissions to read SharePoint data and setting up the Site Collection reports with the Nova application.


Granting access to the Nova Reporting service account

1. Log into the Office 365 portal.

2. In the navigation pane on the left, under Admin centers, select SharePoint. This will take you to the SharePoint admin centers in a new window.

3. In the Admin center, click on Sites and select the Active sites button.


4. An active site need to be selected from the list in order to display the information blade. Once site you would like to add into Nova Reporting is selected, choose Permissions and then Manage.




5. A new blade window will come up with two options. In the search box search for the name of the Nova Reporting service account you used when you initially signed up for Reporting, add the account and click on Save.


NOTE: If when you signed up you chose ‘Automatic Signup' then the service account will be called 'RadarReporting'


6. The permissions should now be applied to the service account.


NOTES: Sometimes issues in the back-end replication can lead to this not always being the case. To confirm that all has been applied correctly on Microsoft's servers, navigate to your site collection's Administrator Management page. The service account should be listed in the box with the other admins.
More information could be found in Microsoft document.

Adding in your site collection in Nova


NOTE: You must have the Radar Classic or System Administrator roles to complete the following steps.

1.Log into Nova, and go to Settings (the cog icon in the top right corner)

2.From the menu, select Reporting from the Application Settings section


3.Select SharePoint Reports and add add the Site Collection(s) you granted access in steps above. You can do this by either:

a.Entering the SharePoint admin URL for the tenant and clicking Update. This will collect all of the site collections automatically (recommended), or

b.You can add one or multiple Site Collections manually by clicking Add Site Collection, and entering the URLs. Then click Add Site Collections.

4.If the rights are granted correctly the status will change from Pending to Verified after next collection.





After successfully adding your service account, the dashboard will be the first screen you will come across. Here, you will see a variety of reports and widgets already pre-built into Nova, including Active Users by Workload, which shows the amount of users using and not using each Office 365 workload in the previous 30 days.

Dashboards are where you can view your reports immediately; with data being updated every 24 to 48 hours, your dashboard gives you recent results on your Office 365 environment straight away.

Here is an example of a dashboard that shows information about an Office 365 tenant:




See dashboards in action in this video by clicking here.


NOTE: The initial look of your dashboard will depend on your role within Nova.

There are several pre-existing widgets that you can add to your dashboard straight away. To do this:

1.From the dashboard, click Edit, the Add Widgets.

2.Click on the report section you would like to add to the dashboard.

3.Click Save.

Interacting with the data

Many of the charts allow you to hover on segments and drill down to get more detail. For example, where we see the number of users who changed their password within a certain period of time, you can hover on that and you will see the precise amount of users who changed their password. Some other charts have a View Data button, which takes you to additional detail, which you can also download into a CSV file if required.




Dashboards can be edited and customized to meet your needs. You can change the title of the dashboard, move chart widgets around, remove widgets that are not needed, and add new widgets by dragging and dropping them from the list onto the page.


Change the title of a dashboard


You can change the title of a dashboard so it reflects the data within it. For example, if you have a dashboard that only reflects your environment's OneDrive data, you can change the title so the dashboard represents that. To do this:

1.From the dashboard, click Edit in the top right hand corner.

2.Click on the title box and input the your desired title.

3.Once done, click Save.

Configuring, cloning and/or removing widgets

Depending on the type of widget on the dashboard (public, private or system), you have configuration options for each widget. These are:

·Configure widget: this is where you can change widgets that you created using the configurable chart widget. You can not configure any pre-built widget without cloning them first.

·Close widget: you can clone system widgets, and then configure that cloned widget to suit your needs.

·Remove widget: Any widget can be removed from the dashboard.

To configure, clone or remove a widget:

1.On the dashboard, click Edit on the top right hand of the screen.

2.Click the Spanner icon on any widget, and choose your desired option.

3.Click Save.

Move and re-size widgets

You can move and resize widgets across your dashboard.

To move a widget:

1.On the dashboard, click Edit on the top right hand corner.

2.Click and hold the widget you would like to move, and drag to the location you would like it to be.

3.Click Save.

To resize a widget:

1.On the dashboard, click Edit on the top right hand corner.

2.Click and hold the arrow on the bottom right of the widget. You can resize it to your standards; the red preview box will show you how large the widget will be once its resized.

3.Cick Save.

Refreshing the dashboard

On the top right hand of the dashboard, you will see a circular arrow icon. This button refreshes your dashboard and gives you real time results. Under the title, you will see when the dashboard was last updated.


NOC mode

Network Operation Center mode (or NOC mode) clears the screen of all Nova user interface elements, leaving the chosen dashboard. The interface goes from this:



To this:



It is a perfect overview for call center, network operations, or help desk employees.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation