I tried your scripts on a large tenant (10k users, 7k Teams, …) I’ve got some errors during the execution :

| An error occurred while sending the request.
InvalidOperation: C:\temp\temp\Perform-TenantAssessment.ps1:231
Line |
231 | $teamgroup | Add-Member -MemberType NoteProperty -Name “URL” -Val …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Cannot index into a null array.
| Invalid request Status: 400 (BadRequest) ErrorCode: invalidRequest Date: 2024-08-09T09:33:03 Headers: Cache-Control : max-age=0, private Vary : Accept-Encoding
| Strict-Transport-Security : max-age=31536000 request-id : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxclient-request-id : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| x-ms-ags-diagnostic : {“ServerInfo”:{“DataCenter”:”Italy North”,”Slice”:”E”,”Ring”:”3″,”ScaleUnit”:”000″,”RoleInstance”:”MI1PEPF0000031C”}} Date : Fri, 09 Aug 2024
| 09:33:02 GMT
InvalidOperation: C:\temp\temp\Perform-TenantAssessment.ps1:231
Line |
231 | $teamgroup | Add-Member -MemberType NoteProperty -Name “URL” -Val …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Cannot index into a null array.
InvalidOperation: C:\temp\temp\Perform-TenantAssessment.ps1:885
Line |
885 | $user.OneDriveSizeGB = (((($OneDrive | ? { $_.’Owner Prin …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Method invocation failed because [System.Object[]] does not contain a method named ‘op_Division’.

But after 7 hours, the script has finished.

When I tried to open the Excel file, I’ve got an error: “We found a problem with some content in TenantAssessment.xlsx … After the repair, I’ve been able to consult the results. But when I tried to open the PowerBi Report, I’ve got a new error concerning the DisplayName in Teams table because it contains duplicate values.

Thanks for your great job, and thanks for your help.
Thierry

Thanks, that did the trick!

Thanks, that did the trick!

Hey Mark,
I expect the data not showing is because names are concealed in reports, could you check you are allowing names to be shown in reports in the tenant? On the shared mailboxes, that is a bug which I will resolve soon. Without shared mailboxes that page does show up blank.

I’ve found the powerbi report will not load unless I create a shared mailbox and a resource – the table lacks headers when there is no data, and this causes an error. I suspect this would rarely be a problem with a real tenant.

More importantly, I am not getting any data from the fields below, even though it exists.

targetobjectID
targetUPN
TargetMail
MailboxItemCount
MailboxSizeGB
OneDriveSizeGB
OneDriveFileCount

Admin is assigned to the App.

PowerShell 7.7.4
Version Name
2.0.2.182 AzureAD
3.5.1 ExchangeOnlineManagement
2.21.1 Microsoft.Graph
7.8.9 ImportExcel

sure how to check MSAL.PS version

Ok, I have seen this before when a null value is returned for a user in the OneDrive report exported. I will add logic to suppress this error but the export should still work fine?

Hi Sean
Thanks for the followup.

3.5.1 ExchangeOnlineManagement PSGallery

When using PS v7.4.2, I am not getting the “ExchangeOnline exiting” error which I was getting with PS v5.1, but now the script stops at below error as mentioned in my last post.

Line |
885 | $user.OneDriveSizeGB = (((($OneDrive | ? { $_.’Owner Prin …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Method invocation failed because [System.Object[]] does not contain a method named ‘op_Division’.

Regards

H,
What version of the Exchange Online Management module are you using?

Error connecting to Exchange Online…Exiting…
Press Enter to continue…:
PS C:\temp\Assessment> Connect-ExchangeOnline -Certificate $Certificate -AppID $clientid -Organization ($orgdetails.verifieddomains | ? { $_.isinitial -eq “true” }).name -ShowBanner:$false
Function Get-DeviceComplianceSummaryReport cannot be created because function capacity 4096 has been exceeded for this scope.
At C:\Program Files\WindowsPowerShell\Modules\ExchangeOnlineManagement\3.5.1\netFramework\ExchangeOnlineManagement.psm1:766 char:21
+ throw $_.Exception;
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (Get-DeviceComplianceSummaryReport:String) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : FunctionOverflow

Found that using PSv7 works to avoid the above error but now getting below –

InvalidOperation: C:\TEMP\Assessment\Perform-TenantAssessment.ps1:885
Line |
885 | $user.OneDriveSizeGB = (((($OneDrive | ? { $_.’Owner Prin …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Method invocation failed because [System.Object[]] does not contain a method named ‘op_Division’.
PS C:\TEMP\Assessment>