none
How to export the members of all groups (group inside group) from all branches in to excel

    Question

  • Hello everyone,

    basically, I can work with powersehll in very first level and not good at all with scripting.

    My boss has asked me to create an excel table which should contains all the users from all branches and clearly indicate that which user is in which groups.

    In my enviroment, we have many groups that are member of another group for better Info disterbution.

    Can anyone help me with this, please?

    Best regards,

    Jawad

    Monday, March 20, 2017 8:51 AM

All replies

  • May help;

    https://gallery.technet.microsoft.com/scriptcenter/a2d6475e-50e6-4367-9aa4-c19a60674157


    This posting is provided AS IS with no warranties or guarantees,and confers no rights. Best regards Burak Uğur

    Monday, March 20, 2017 10:22 AM
  • Thanks Burak,

    but this script is being tested on 2003 and I'm not sure if its going to work with 2012, although I have tried it, but didn't work.

    Monday, March 20, 2017 10:51 AM
  • OK,try this (verified with server 2012)

    https://gallery.technet.microsoft.com/scriptcenter/Get-members-from-a-list-of-be57511c


    This posting is provided AS IS with no warranties or guarantees,and confers no rights. Best regards Burak Uğur

    Monday, March 20, 2017 11:13 AM
  • I knew the link, I have tried with it last week, not working in my case, I don't know why, maybe I'm editing it wrongly :(.
    Monday, March 20, 2017 2:54 PM
  • Hi Jawad,
    Appreciate you posting the questions in the Directory Services forum. However, since the issue relates to script, I would suggest you post the question in scripting forum.
    https://social.technet.microsoft.com/Forums/scriptcenter/en-US/home?forum=ITCG
    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
    Best regards,
    Wendy

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Tuesday, March 21, 2017 7:30 AM
    Moderator
  • Hi Wendy,

    Thank you for the info, I have just did so.


    Monday, March 27, 2017 1:18 PM
  • I have looked at the first script Burak linked above, and it should work fine with Windows Server 2012.

    Richard Mueller - MVP Enterprise Mobility (Identity and Access)

    Monday, March 27, 2017 1:37 PM