Skip to content

Error when all eligible entra role assignments are of type group #727

@apraamsm

Description

@apraamsm

When Eligible Entra role assignments are all of type group the assessment fails with error:

Exception: /Users/username/.local/share/powershell/Modules/ZeroTrustAssessment/2.1.13/private/export/Export-Database.ps1:115
Line |
117 | Invoke-DatabaseQuery -Database $Database -Sql $sql -NonQuery
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Exception calling "ExecuteNonQuery" with "0" argument(s): "Binder Error: Could not find key "userprincipalname" in struct Candidate Entries:
| "uniqueName""

OS: MacOS 26.2 (25C56)
Pwsh: 7.5.4
Module: 2.1.13 preview

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingtriaged

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions