export AD groups

Question

Hi All

i have a csv file and it has 600 AD groups mentioned in it in the below format, the csv file is not in proper format. only the first 3 characters(100, 111,112,120) are correct. is it possible to get the exact AD group names by importing the csv using the first 3 characters. i want the samaccount names and description of the AD groups, is it possible to fetch this information. please guide me

groups
100-abc
111xyz
112-uiy
120_poi

Answer 1

If the groups names "100", "111", "112", "120" then you can do it pretty easily.

Maybe something like this:

Import-CSV -c:\junk\groups.csv |
    ForEach-Object{
        $groupname = ($_.groups).substring(0,3)
        Get-ADGroup -Filter "name -eq $groupname" |         # you may need to add a -Properties list; or change "-eq" to "-like"
            Select-Object Name, ssmAccountName, Description
    } | Export-CSV c:\junk\group-extract.csv -NoTypeInformation

Answer 2

i tried the above syntax i am getting blank output

Answer 3

Hello,

In theory, for pulling out groups you can use Get-ADGroup:

Get-ADGroup -Filter {name -like "100-abc*"} -Properties Description | Select Name,Description

Then loop through the results (either CSV or directly off of the command above) and use Set-ADGroup to make your changes.

Help Set-ADGroup -Full

Regards,