| Report Name | Report Description | Data Refreshed | Status |
| ATP Group Management Report | Lists all ATP groups for the selected organisation and gives information on the owners, creation date, last updated date and members. The report will not show groups that are part of closed organisations or that have no owners | Constantly updated | Available |
| ATP User Management Report | Lists what ATP groups the members of the selected organisation are a part of | Constantly updated | Available |
| Azure AD Allowed list External Organisations | List of external domains that have been requested in portal as a part of the allow list | Constantly updated | Available |
| Azure AD External Federated Groups Report | List of federated groups that have been created in portal | Constantly updated | Available |
| Azure AD Guest Access Report | List of guest users that have been added in portal | Constantly updated | Available |
| Connector Report | Lists all accounts created using a connector or CSV upload functionality | Constantly updated | Available |
| Contact Report | Lists the details of all the contacts within the selected organisation, including the information visible on the Portal Admin pages as well as the contact’s Local ID | Constantly updated | Available |
| Dashboard Report | Lists organisational data for Global and Tenant Admins | Constantly updated | Available |
| Distribution List Report | Lists the details of all the distribution lists set up by the selected organisation including the details visible on the Portal Admin pages as well as the distribution list’s Local ID | Constantly updated | Available |
| Mailbox Report | Lists the details of all the users within the selected organisation, including the information visible on the Portal Admin pages (such as First Name, Last Name, Id, Title, Display Name, Mailbox Type, Mailbox Location, User Policy Name, Status, Email Address, Telephone, Mobile, Department, Job Title, Mailbox Size (GB),Created On, Last Updated, Last LogIn, Updated By, ODS Code, Organisation Name, Organisation Unit Name, Name of the Parent Organisation , AUP Status, Mark As Leaver Date, Site Name, Role, Account Type, User Mailbox Usage (Bytes), User Mailbox Usage (GB), User Dumpster Usage (Bytes) and User Dumpster Usage (GB, )MSLive Events Enabled, MFA Status etc.) and the user’s Local ID | Monday weekly | Available |
| MFA Status Report | Lists the MFA Status of all users within the selected organisations, including Compromised Status, date when Compromised/Remediated, who by, and amount of times a user has been Marked As Compromised | Daily | Available |
| Mobile Report | Lists all details of the mobile devices registered for all users in the selected organisation. For known issues, please refer – Mobile Report Not Providing Correct Data – PRB0183567 | Monday weekly | Not Active |
| Mover Leaver Report | Lists all accounts (Users, Shared Mailboxes, Distribution Lists, Resource Mailboxes and Contacts) which joined, left the organisation or were transferred in the past 12 months | Constantly updated | Available |
| O365 Activations User Detail Report | Lists Software Activations details such as Report Refresh Date, User Principal Name, Display Name, Product Type, Last Activated Date on devices like Windows, Mac, Windows 10 Mobile, iOS, Android and On Shared Computer | Daily | Available |
| O365 Licence Report | Lists details of the O365 licences of the selected organisation (such as Subscription ID, Organisation Name, Licence Type, Total Licences, Total Consumed Licences, Available Licences, Start Date, Expiry Date, Status, Updated Date) | Constantly updated | Available |
| O365 National Licence Report | Lists details on the number of national licences currently being consumed by the selected organisations | Constantly updated | Available |
| O365 Privacy Report | Provides the privacy settings for Teams, SharePoint, Stream sites. This report lists the type of service (Team, SharePoint, Group or Stream), identifier and the privacy setting | Daily | Available |
| O365 User Licence Allocation Report | Lists details of the O365 licences of the selected organisation (such as Subscription ID, Organisation Name, Licence Type, Total Licences, Total Consumed Licences, Available Licences, Start Date, Expiry Date, Status, Updated Date) | Constantly updated | Available |
| O365 Usage Active User Detail Report | Lists information on the usage of each of the O365 apps a user has access to. This includes: Report Refresh Date, User Principal Name, Display Name, Is Deleted, Deleted Date, Has Exchange License, Has OneDrive License, Has SharePoint License, Has Yammer License Has Teams License, Exchange Last Activity Date, OneDrive Last Activity Date, SharePoint Last Activity Date, Yammer Last Activity Date, Teams Last Activity Date, Exchange License Assign Date, OneDrive License Assign Date, SharePoint License Assign Date, Yammer License Assign Date, Teams License Assign Date, Assigned Products. | Sunday Weekly | Available |
| OneDrive User Consumption report | Comprises the OneDrive site details such as the site URL, the name of the site’s owner, whether the site has been deleted, date of last activity on the site and the owner principal name (NHSmail address) of site owner. The report details different aspects of OneDrive as the number of active files, storage used, and the storage allocated. The file count on the site is also recorded, as well as the report refresh date and the report period. Please use this link to get a detailed view and explanation of the columns for this report OneDrive User Consumption Report- Glossary.PDF | Sunday weekly | Available |
| Organisation Admin Report | Lists all administrators for the selected organisation | Constantly updated | Available |
| Organisation Traffic Report | Lists the number of emails sent or received for the organisation | Daily | Available |
| Possible Duplicate Users Report | Lists possible duplicate users where there is more than one person with the same first and last name in an organisation and the status is active | Constantly updated | Available |
| Shared Channels Report | Lists all users with shared channels enabled and the shared channel policy that has been applied. If no shared channel policy has been applied to a user, they will not appear in report. | Constantly updated | Available |
| SharePoint Site Usage Detail Report | Lists the key attributes per SharePoint site such as the site Id, site URL, name of site owner, owner principal name (NHSmail address) of site owner, whether the site was deleted and date of last site activity. The report also details key aspects of the SharePoint Collection such as the counts of active files, page views, page visits, and the root web template used per SharePoint Collection. The report details the storage used, storage allocated, report period and the report’s refresh date. Please use this link to get a detailed view and explanation of the columns for this report. Known issue acknowledgement – SharePoint Site Usage Detail Report Providing Incomplete or Blank Data – PRB0218343 | Sunday weekly | Not Active |
| Teams Usage Report | The Teams usage report provides an overview of the number of teams and channels across your organisation using Teams to communicate and collaborate. You can view information of all the Teams in your organisation including the Teams name, privacy, mail nickname, Teams email, Channel count, Team owners count, Team members count, Team guests count and Teams creation date.. Known issue acknowledgement – Inaccurate Data in Teams Usage Report – PRB0206639 | Sunday weekly | Available upon Request |
| Teams User Activity Report | Lists details for the activities performed by the users in Teams (such as Refresh Date, User Name, Last Activity Date, Status, Deleted Date, Assigned Products, Team Chat Message Count, Private Chat Message Count, Call Count, Meeting Count, Has Other Action, Report Period). Please use this link to get a detailed view and explanation of the columns for this report – Teams Usage Activity Report- Glossary.PDF | Sunday weekly | Not Active |
| Top Up report | Lists the current and past subscriptions held by all users within the selected organisation. | Constantly updated | Available |
Generating Admin Reports:
Click Reports in the navigation bar at the top of the screen and select Admin Reports from the drop down menu.
Select the target organisation and reports from the drop down menus. If you do not select an organisation, the default “All my organisations” is selected.
Generate Report
The Admin Report will begin to download and will show when complete in your tool bar at the bottom of the page (this may differ depending on your browser version)
Additional Reporting
In addition to the reports listed above which can be generated at an organisation-level, Local Administrators (LAs) have access to reporting functionality through a user policy. Please see below:
Export Licensing Errors
This report can be generated at a user-policy level enabling LAs to check for licensing errors against any members associated with the user policy. In this way, LAs can identify whether any users have licensing errors, the specific licence which is presenting an error and the reason for failure.
To generate this report, LAs are required to carry out the following steps:
1. Within the NHSmail Portal, navigate to Admin > User Policy Management
2. Select the User Policy you wish to run the report for
3. Within this User Policy, click on Export Licensing Errors
4. You will see a pop up in the portal showing the report was successfully requested.
5. An email will be sent to you indicating whether any licencing errors were found against the policy. If so, the email will contain an attached CSV file. The CSV file will contain a view on all members assigned to the policy who are presenting a licensing error and indicate the licence which has not been effectively assigned, alongside the reason for failure. Please note, in instances where a member has multiple licenses which are presenting errors, this will be displayed as separate lines on the CSV file.
6. If any users are identified as having a licensing error associated with them, LAs should raise a ticket to the NHSmail helpdesk and provide a list of the affected users and the licensing errors against each.
| Last Reviewed Date | 15/04/2024 |
