Share via

Export the personnel name and subgroup name of the AD group in the list

Daniel Wu 1 Reputation point
2022-03-02T00:13:08.227+00:00

I have a list of AD groups in CSV format.I have to export the personnel name and subgroup name of the AD group in the list to the other CSV file.
dsquery group -name "NAME" | dsget group -members >c:\NAME.csv179025-2022-03-01-17-31-32-listcsv-excel.png179026-2022-03-01-17-37-34-listcsv-excel.png
so how to write a vbs ?

Windows for business | Windows Client for IT Pros | Directory services | Active Directory
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Carlos Solís Salazar 18,191 Reputation points MVP Volunteer Moderator
    2022-03-02T12:14:43.283+00:00

    In Excel, you have in the home tab the function "Analyze Data" https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4

    With that tool, you can create a pivot table and/or graphs from the raw data.

    Hope this helps.

    Please "Accept as Answer" and Upvote if any of the above helped so that, it can help others in the community looking for remediation for similar issues.

    Regards,
    Carlos Solís Salazar

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.