OneDrive list of admin

Question

Hello,&nbsp;We have a user who was accidentally added as site collection admin to various OneDrive accounts. Is it possible to pull a list of all site collection admin for all OneDrive accounts?&nbsp;I've tried using the following cmdlet on one of the sites before creating the full script.get-spouser -Site "&lt;site url&gt;" | select DisplayName, LoginName, UserType, IsSiteAdmin&nbsp;The above returns all site users with isSiteAdmin as false unless I grant my admin account&nbsp;as site collection admin which is not ideal solution.&nbsp;&nbsp;Running Get-Sposite returns only primary site collection admin.&nbsp;&nbsp;Which should be the best way to pull list of all site collection admins?&nbsp;Thank you.B

vasilmichev · Answer

One way to do this is to get the Audit log events corresponding to the "add site collection admin" activity: https://docs.microsoft.com/en-us/office365/securitycompliance/search-the-audit-log-in-security-and-compliance#site-administration-activities

bhavpreet bains · Answer

is there a script or cmdlet that I can use?

joe james · Answer

Do you have access to tool like ShareGate - if you have you can easily remove the user from all sites or list of sites. If you don't have you could easily script it out.&nbsp;https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/remove-pnpsitecollectionadmin?view=sharepoint-ps

vasilmichev · Answer

Yes, you can use the Search-UnifiedAuditLog cmdlet: https://docs.microsoft.com/en-us/powershell/module/exchange/policy-and-compliance-audit/search-unifiedauditlog?view=exchange-ps

Forum Discussion

OneDrive list of admin

4 Replies

Resources