Trying to do a few different things with AD

So, I'm the new guy who doesn't have a lot of Powershell experience. I've got a rolling requirement within AD, so let me try to best desribe what I'm looking for.

I need something that can do the following:

- Pull various user groups from AD (I would have to define them by group name)

- Output each group name to it's own sheet in an Excel document

- Populate each Excel sheet with the users contained within each group

I have a something that can pull users from AD groups, and I'm able to create an Excel doc wioth differently named sheets from an existing document, but I'm not able to figure out how to get them together automatically.

I am just hoping someone already has something like this and it won't be too intensive.

If not, oh well, will just keep tinkering 'til I get it sorted.

Thanks for taking the time to read through this!

  • As for ...
    So, I'm the new guy who doesn't have a lot of Powershell experience.

    This is fine. We all have to start somewhere, but this means at minimum getting some ramp up. See the below and live on YouTube, MSDN Channel 9 and do a search for 'beginning powershell' and 'Powershell using adctiive directory'.

    Use any Windows tool that will write the baseline code for you (which you can then tweak), such as the Windows Server 2012 ADAC console leveraging the PowerShell History Viewer.

    Active Directory Administrative Center: Getting Started
    'technet.microsoft.com/.../dd560651(v=ws.10).aspx'

    Active Directory Administrative Center
    'docs.microsoft.com/.../active-directory-administrative-center'

    Step-By-Step: Utilizing PowerShell History Viewer in Windows Server 2012 R2
    'blogs.technet.microsoft.com/.../step-by-step-utilizing-powershell-history-viewer-in-windows-server-2012-r2'

    MOC on-demand, if you cannot go in person.
    https://www.microsoftondemand.com/courses/microsoft-course-10961
    https://www.microsoftondemand.com/courses/microsoft-course-10962

    See also:
    https://docs.microsoft.com/en-us/powershell
    https://community.idera.com/database-tools/powershell/using_powershell/f/general-12/68263/getting-started-with-powershell


    As for ...
    - Pull various user groups from AD (I would have to define them by group name)

    A common everyday thing. Fully documented in the built-in Help files and all over the web. See the links above.


    - Output each group name to it's own sheet in an Excel document
    - Populate each Excel sheet with the users contained within each group

    Just export to .csv using the built-in cmdlets, and open in Excel
    There are PowerShell Excel modules on the MS PowerShellGallery.com. Download and use one or the other.

    Find-Module -Name '*excel*' | Format-Table -AutoSize

    Version     Name                          Repository Description                                                                                                 
    -------     ----                          ---------- -----------                                                                                                 
    5.4.5       ImportExcel                   PSGallery  PowerShell module to import/export Excel spreadsheets, without Excel....                                    
    0.0.17      PSWriteExcel                  PSGallery  Little project to create Excel files without Microsoft Excel being installed.                               
    1.0.2       PSExcel                       PSGallery  Work with Excel without installing Excel                                                                    
    18.0.6883.0 ExcelCmdlets                  PSGallery  CData Cmdlets for Excel                                                                                     
    18.0.6883.0 ExcelServicesCmdlets          PSGallery  CData Cmdlets for Excel Services                                                                            
    0.6.9       ExcelPSLib                    PSGallery  Allow simple creation and manipulation of XLSX file                                                         
    18.0.6883.0 ExcelOnlineCmdlets            PSGallery  CData Cmdlets for Excel Online                                                                              
    0.1.6       BitTitan.Runbooks.Excel       PSGallery  PowerShell module for Excel-related functions and resources used in BitTitan Runbooks                       
    0.1.6       BitTitan.Runbooks.Excel.Beta  PSGallery  PowerShell module for Excel-related functions and resources used in BitTitan Runbooks                       
    0.0.1       ProductivityTools.PSExcel2SQL PSGallery  Module takes all excel files in given directory and push the content to database.


    As for this...

    I have a something that can pull users from AD groups, and I'm able to create an Excel doc wioth differently named sheets from an existing document, but I'm not able to figure out how to get them together automatically.

    You need to define this more or show your code and expected output. Yet, again, those modules should help you. Specifically the first two.