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
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
i tried the above syntax i am getting blank output
Sorry! Line #3 was missing the letter "s" at the end if the word "group". I've fixed the code sample.
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,
You really should try reading the entire question!
Here. I'll quote the relevant parts for you:
only the first 3 characters(100, 111,112,120) are correct.
and:
using the first 3 characters
20 people are following this question.
