Exporting Specific Users to a .csv

George Pinkasiewicz 20 Reputation points
2024-06-04T16:58:54.05+00:00

Company A, purchases Company B.

Company A, integrates all office 365, Teams, and Sharepoint of company B

Company A, sells company B to Company C

How do I get a list of

Company B: office 365 users

Company B: Teams' Channels

Company B: Sharepoint sites

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,140 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,058 questions
Accepted answer
  1. Ling Zhou_MSFT 14,845 Reputation points Microsoft Vendor
    2024-06-06T06:16:59.78+00:00

    Hi @George Pinkasiewicz,

    Thank you for posting in this community.

    First, try to see if you can use the administrator account of tenant B to access https://admin.microsoft.com/Adminportal/Home#/homepage and

    https://tenantB-admin.sharepoint.com/(Please change your tenant's real name.).

    If you can, then you can export the list of tenant B users directly in M365 Admin Center > User > Active users.

    User's image

    Export the SharePoint sites created by tenant B directly in SharePoint Admin Center >Sites >Actives sites.

    User's image

    If you can't do it in the first step, then we need to do something a little more complicated.

    In the Active users' page, you can filter users based on domain name before exporting.

    User's image

    User's image

    But for SharePoint sites, we don't have a way to distinguish which domain the site was created by a user for the time being, so we can only export them all and then manually distinguish them. Unfortunately, this can be complicated and time-consuming, but there is no better way.

    As this forum is assigned to the support team of the relevant product by the question tag. We're responsible for the SharePoint product, so for the export of channel channels in Teams, we recommend that you re-ask questions in this forum and add the Teams tag so that the Teams team can discover your issue.

    If the answer is helpful, please click **"Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".**Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jeff Holliday 0 Reputation points
    2024-06-05T04:35:15.4633333+00:00

    Are there any markers, classifications, etc.? For users I would imagine you could pull them by the original Company B email domain if those users have them as an alias (@companyb.com).

    Once you have those list of users you should be able to run PowerShell scripts to find all data those users own in SharePoint sites.