microsoft / coe-starter-kit

Other
754 stars 225 forks source link

[CoE Starter Kit - Feature]: Include user principal name in admin_environmentsecurityrolepermission table #6441

Open bhavikj65 opened 1 year ago

bhavikj65 commented 1 year ago

Is your feature request related to a problem? Please describe.

This is not related to a problem, however it would make it easier to filter users if their UPN is included in the admin_environmentsecurityrolepermission table.

Describe the solution you'd like

It would be nice to include user principal name in admin_environmentsecurityrolepermission table where we have all System Admin users. Currently, it only has admin_name & admin_userid which gets Display Name of the user and Object ID.

Please also include user principal name of the users as that will help identify business users and we could exclude tenant admins who by default get this role.

Describe alternatives you've considered

No response

Additional context?

No response

Jenefer-Monroe commented 1 year ago

Thank you for posting, I cant find a quick and easy to ship this fast so adding to feature backlog