Powershell – Get-DistributionGroup output ManagedBy samaccountname

exchangepowershell

I am trying to export a list of all DL's, and I need to be able to have a column with the samaccountname of the ManagedBy value (first entry if multiple).

Get-DistributionGroup | Select-Object Name, ManagedBy | Export-Csv C:\out.txt

Unsurprisingly, this gives me something like this:

"Name","ManagedBy"
"DL-SOMETHING-SOMETHING","Microsoft.Exchange.Data.Directory.ADMultiValuedProperty`1[Microsoft.Exchange.Data.Directory.ADObjectId]"

If this was not a one-liner, I could loop through the ManagedBy values, use GET-AdUser and extract what I need.

But can I do this in a one-liner, if I only care about the first ManagedBy?

Something like…

Get-DistributionGroup | Select-Object Name, ManagedBy[0].Samaccountname | Export-Csv C:\out.txt

If I could even get the same string as I get when I run this in the console, I could work with that:

Get-DistributionGroup | Select-Object Name, ManagedBy

Output

DL-SOMETHING-SOMETHING, {somedomain.com/Accounts/SomeAccount}

Best Answer

Try below command:

Get-DistributionGroup | Select-object Name,@{label="ManagedBy";expression={[string]($_.managedby | foreach {$_.tostring().split("/")[-1]})}} | Export-Csv

It will display like below:

Related Solutions

Powershell – Exporting specific fields with powershell’s export-csv

You want to use the Select-Object cmdlet in place of Format-Table. This should work for you:

| select-object givenname,sn,company,telephonenumber,mail `
| export-csv -Delimiter `t -NoTypeInformation -Path c:\scripts\adexport.csv

Active Directory – How to List All Active Directory Users and Their Group Membership

Install the Quest CMDlets and then run this code:

Add-PSSnapin Quest.ActiveRoles.ADManagement
$memberships = @()

Get-QADGroup -SizeLimit 0 | Foreach-Object {
        $NameGroup = $_.Name
        Write-Host "Working with $NameGroup"
        $membership = Get-QADGroupMember $_.DN -Enabled -SizeLimit 0
        if ($membership -ne $null ) {
        $membership | Add-Member -type NoteProperty -name AuditGroupUserIsMemberOf -value $_.Name
        $memberships += $membership
        }
    }

$memberships | Select-Object AuditGroupUserIsMemberOf, NTAccountname | Export-Csv "GroupsWithUsers.csv"

This will give you a 1 record per group-user connection so expect multiple occurrences of users and groups. If you wan't other fields, you can just edit the Select-Object statement. Use $memberships | gm to see all the possibilities for the users. If you want more fields for the groups, use Get-QADGroup | gm, you will then need to add these by adding a new NoteProperty.

If you don't really care about more options, here is a one-liner you can just mash in the terminal:

Get-QADGroup -sizeLimit 0 | select @{name="Group";expression={$_.name}} -expand members | select Group,@{n='User';e={ (Get-QADObject $_).NTAccountName}} | Export-Csv "MyUsersAndGroups.csv"

Best Answer

Related Solutions

Powershell – Exporting specific fields with powershell’s export-csv

Active Directory – How to List All Active Directory Users and Their Group Membership

Related Topic