Solved

Exchange PowerShell Script

Posted on 2013-11-25
5
341 Views
Last Modified: 2013-11-25
Hi Experts,

Need a script that could do the following:

Scan all distribution groups and list all members email address that is not equal to @domain.com that is associated to that distribution group.

Is this possible and how. Thanks in advance.

Regards,

introlux
0
Comment
Question by:introlux
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Sean
ID: 39674795
Here is a script to get all groups and their members...if you play with it you could probably only get the members you want to but if you only need to run it once i would just use excel to remove the users you don't need.

$Groups=Get-DistributionGroup

$Groups| foreach{

$GroupName=$_.Name

$Report+=Get-distributionGroupMember -identity $_.identity| select @{Name='Distribution Group'; Expression={[String]::join(";", $GroupName)}}, Name, PrimarySmtpAddress}

$Report| export-csv "c:\MyFile.csv" -notype
0
 

Author Comment

by:introlux
ID: 39674885
error:

Export-Csv : Cannot bind argument to parameter 'InputObject' because it is null
.
At C:\test.ps1:5 char:20
+ $Report| export-csv <<<<  "c:\MyFile.csv" -notype
    + CategoryInfo          : InvalidData: (:) [Export-Csv], ParameterBindingV
   alidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,M
   icrosoft.PowerShell.Commands.ExportCsvCommand
0
 
LVL 9

Accepted Solution

by:
Sean earned 500 total points
ID: 39674905
Try and run it without exporting to CSV first:

$Groups=Get-DistributionGroup

$Groups| foreach{

$GroupName=$_.Name

Get-distributionGroupMember -identity $_.identity| select @{Name='Distribution Group'; Expression={[String]::join(";", $GroupName)}}, Name, PrimarySmtpAddress}


let me know if it still errors out for you.
0
 

Author Comment

by:introlux
ID: 39674936
That worked thanks!
0
 

Author Closing Comment

by:introlux
ID: 39674938
A++
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The following article is intended as a guide to using PowerShell as a more versatile and reliable form of application detection in SCCM.
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data‚Ķ
This video discusses moving either the default database or any database to a new volume.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question