Hello, 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? I've tried using the following cmdlet on one of the site before creating the full script.get-spouser -Site "<site url>" | select DisplayName, LoginName, UserType, IsSiteAdmin The above returns all site users with isSiteAdmin as false unless I grant my admin account as site collection admin which is not ideal solution. Running Get-Sposite returns only primary site collection admin. Which should be the best way to pull list of all site collection admins? Thank you.B

I’m playing with a script but so far all I get is all the onedrive sites and the original corresponding owner, even if I added someone else as owner as well.IsSiteAdmin doesn’t return any value

I wish I had a solution, but I don't. I can just add a "Me Too". The only thing I can think of is to write a script that does the following:Check the adminsIf I get results, greatIf I get no results, grant myself accessGet the listRemove my accessI'm amazed that Get-SPOSite and Get-SPOUser have this limitation for Global admins and SharePoint admins, and that Microsoft hasn't worked around this by providing an Audit report from the Office 365 or SharePoint Admin sites.

Try this: https://jerryyasir.wordpress.com/2017/05/31/get-site-collection-administrators-for-sharepoint-online-using-powershell/

Hello Juan,I've tried the following cmdlet but it doesn't return isSiteAdmin true.get-spouser -Site "<site url>" | select DisplayName, LoginName, UserType, IsSiteAdmin

Have not looked at the script yet, but you have to be a owner yourself to be able to read the other site collection admins. Not sure if that is the problem.

Bhavpreet Bains

Iron Contributor

Oct 09, 2018

onedrive list of admin

Hello,

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?

I've tried using the following cmdlet on one of the site before creating the full script.

get-spouser -Site "<site url>" | select DisplayName, LoginName, UserType, IsSiteAdmin

The above returns all site users with isSiteAdmin as false unless I grant my admin account as site collection admin which is not ideal solution.

Running Get-Sposite returns only primary site collection admin.

Which should be the best way to pull list of all site collection admins?

Thank you.

OneDrive for Business

jcgonzalezmartin
MVP
Oct 09, 2018
Try this: https://jerryyasir.wordpress.com/2017/05/31/get-site-collection-administrators-for-sharepoint-online-using-powershell/
- Bhavpreet Bains
  Iron Contributor
  Oct 09, 2018
  Hello Juan,
  
  I've tried the following cmdlet but it doesn't return isSiteAdmin true.
  get-spouser -Site "<site url>" | select DisplayName, LoginName, UserType, IsSiteAdmin
  - adam deltinger
    MVP
    Oct 09, 2018
    I’m playing with a script but so far all I get is all the onedrive sites and the original corresponding owner, even if I added someone else as owner as well.
    IsSiteAdmin doesn’t return any value

Forum Discussion

onedrive list of admin

Share

Resources