And a simple search will find lots of examples, like https://office365itpros.com/2022/12/06/distribution-list-membership-sdk/

I certainly could provide such a script, but you’ll find that it will take you a little time to write the script and at the end of the experience, you’ll feel much better that you did it rather than me.

Could you please provide an script to extract/report with all distribution groups (static and dynamic) with the following columns.

Displayname, Members Count, AcceptMessagesOnlyFrom, ModerationEnabled, ModeratedBy

Thanks for the script.
when i am using below lines, its not counting the members in child groups. can you please help on it.

#Get distribution groups
$distgroups = @(Get-ADObject -LDAPFilter “(&(objectclass=group)(mail=*))” -Properties name, distinguishedName, managedby, mail)

#Process each distribution group
foreach ($dg in $distgroups)
{
$count = @(Get-ADGroup $dg.distinguishedname -Properties member |Select-Object -ExpandProperty member|Get-ADObject -Properties Samaccountname,DistinguishedName |select Samaccountname,DistinguishedName,ObjectClass).Count

That’s the count of objects in the DL. It doesn’t expand nested DLs into their members.

(Get-DistributionGroupMember -Identity “Name of your group”).count

Thought This might help people who has more than 5000 member’s groups

#Get distribution groups
$distgroups = @(Get-ADObject -LDAPFilter “(&(objectclass=group)(mail=*))” -Properties name, distinguishedName, managedby, mail)

#Process each distribution group
foreach ($dg in $distgroups)
{
$count = @(Get-ADGroup $dg.distinguishedname -Properties member |Select-Object -ExpandProperty member|Get-ADObject -Properties Samaccountname,DistinguishedName |select Samaccountname,DistinguishedName,ObjectClass).Count

any workaround for this restriction of 5000?