I’ve thought of creating a different tool after creating the PowerShell Office 365 tool a couple of days ago to improve my PowerShell coding and to make my work and that of my colleagues a little bit easier. The PowerShell Office 365 inventory tool lists a lot of information you would like to see when troubleshooting or getting information from a tenant you never connected to.
You can follow and download the PowerShell Office 365 Inventory Tool at GitHub: https://github.com/peetersm12/Office365Inventory-GUI
This PowerShell Office 365 Inventory tool will retrieve the following information:
- Azure Active Directory Users
- Azure Active Directory Deleted Users
- Azure Active Directory External Users
- Azure Active Directory Contacts
- Azure Active Directory Groups
- Azure Active Directory Licenses
- Azure Active DIrectory Domains
- Exchange Mailboxes
- Exchange Archives
- Exchange Groups
- SharePoint Sites
- SharePoint Webs
Please note that you will need a few pre-requisites before fully able to run this tool:
- Microsoft Online Services Sign-In Assistant for IT Professionals RTW.
- Azure Active Directory PowerShell V1 or preferable v2 because of the other PowerShell Office 365 Tool
- SharePoint Online Management Shell
Please let me know which information you would like to see added to this tool and I’ll add this is as soon as possible.
[How to] PowerShell Office 365 Inventory Tool
Run ‘Start-Office365Inventory.ps1’. You will automatically be asked to run as administrator if you ran this as a normal user.
First Connect to Office 365 by clicking on the credential logo, by pressing f4 or via the menu
Fill in your credentials and press OK
You are connecting successfully when the icons are green.
There are 2 possible actions now:
- Navigate to a tab and run only this action
- Press the run all button to run all available actions
Only the Azure Active Directory Licenses have been returned. You can verify which actions have been run on the home tab.
Now click on the run all actions button. You can see the progress on the Home tab.
Please note that you will need site collections permissions for the SharePoint Webs option as this uses CSOM to connect to the different webs.
You will receive the following message but it will continue looking for more webs
After all actions everything should be green
Run the action individually if you encounter an error as the exception will be shown in the below message center.
Reports
You can create a .CSV or .HTML file based on the items visible at any time in the view by clicking on the button next to the CSV Report.
The report will be saved to the report folder located in the script root.
The .CSV report will look like:
The .HTML report will look like:
It is also possible to create a .HTML file for all the available tabs in a nice format. Please note that this is still a work in progress but it will lists everything at the moment.
Error log
Some error information is displayed on the background PowerShell window as other information is only readable using the errorlog.
Please send me this information and the message in the below message box if you encounter an error.
