Results 1 to 8 of 8

Sort Active Directory users by group

Threaded View

denisuu Sort Active Directory users... 03-25-2019, 06:24 AM
Olly Re: Sort Active Directory... 03-25-2019, 09:08 AM
denisuu Re: Sort Active Directory... 03-25-2019, 03:13 PM
JeteMc Re: Sort Active Directory... 03-27-2019, 11:48 PM
denisuu Re: Sort Active Directory... 03-28-2019, 11:22 AM
JeteMc Re: Sort Active Directory... 03-28-2019, 11:41 AM
denisuu Re: Sort Active Directory... 03-29-2019, 03:20 AM
JeteMc Re: Sort Active Directory... 03-29-2019, 08:40 AM
  1. #1
    Registered User
    Join Date
    03-25-2019
    Location
    Brussels, Belgium
    MS-Off Ver
    2016 Pro
    Posts
    4

    Sort Active Directory users by group

    Hi,

    I made a Powershell script to extract all groups and users. The output is a .csv file that looks like this.

    HTML Code: 
    I separate them them like this.
    Data > text to column > Delimited by Comma

    Group "member" enabled
    Admin Pietsje Overmars True
    Admin Reinder Wortel True
    Admin Karima Hazewinkel False
    HR Wouterina Keulemans True
    HR Phaedra Lugt True
    IT Marlin Moens False
    IT Manuel Dongelmans True

    I want the output to look like this with the users that are disabled (False) in red or strike-through:

    Admin HR IT
    Pietsje Overmars Wouterina Keulemans Marlin Moens
    Reinder Wortel Phaedra Lugt Manuel Dongelmans
    Karima Hazewinkel

    I only get something that is remotely similar to what I want when I put both Group and Member under ROWS in a PIVOT-TABLE. When I ad enabled to filter I can select True or False which is nice but not really necessary. They should be next to each other (blank) and Grand Total should be gone.
    Attached Images Attached Images
    Last edited by denisuu; 03-25-2019 at 06:26 AM. Reason: Added additional info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 04-18-2014, 05:54 PM
  2. Pull Active Directory Group Information into Excel
    By jam92102 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-20-2014, 04:32 PM
  3. Replies: 0
    Last Post: 09-05-2013, 10:00 AM
  4. How to add user to active directory group
    By Silencer001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2013, 04:45 PM
  5. Active Directory Help
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2011, 07:27 AM
  6. Get User Name - Active Directory
    By jai2808 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2007, 05:20 AM
  7. Active Directory References? help...
    By Judith in forum Excel General
    Replies: 1
    Last Post: 10-12-2006, 04:14 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1