techdrive
asked on
powershell select multiple fields using -expandproperty and arrange in columns exchange 2010
Good Evening I need some assistance please. I am using the following command below
get-distributiongroup -identity "groupname" | select managedby -expandproperty | select name
Now this command is great as it gives me just the name without the long path. I was trying to pull another value like the name of the group in a foreach like
This fails when trying to pull multiple fields
get-content c:\nameofdlgroups.csv | foreach { get-distributiongroup -identity $_ } | select managedby -expandproperty , displayname| select name, displayname
My end goal is to get the output to display like this below in a csv file. Its just hard displaying the name of the group plus the multiple owners of the group.
group name
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
group name1
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
group name2
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
group name3
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
get-distributiongroup -identity "groupname" | select managedby -expandproperty | select name
Now this command is great as it gives me just the name without the long path. I was trying to pull another value like the name of the group in a foreach like
This fails when trying to pull multiple fields
get-content c:\nameofdlgroups.csv | foreach { get-distributiongroup -identity $_ } | select managedby -expandproperty , displayname| select name, displayname
My end goal is to get the output to display like this below in a csv file. Its just hard displaying the name of the group plus the multiple owners of the group.
group name
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
group name1
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
group name2
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
group name3
groupmanagedbymember23
groupmanagedbymember13
groupmanagedbymember73
groupmanagedbymember012
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think this might work and thanks also Chris Dent
$OutFile = $output = "c:\temp\gmembers.txt"
$MyList=get-content "c:\nameofdlgroups.csv" |get-distributiongroup | select displayname -expandproperty managedby | select displayname,name
output = `
foreach($MyItem in $MyList){
if ($MyprevItem -ne $MyItem.DisplayName){
$MyItem.DisplayName
" $($MyItem.Name)"
$MyprevItem=$MyItem.Displa yName
} else{
" $($MyItem.Name)"
}
}
$Output | Out-File $OutFile -Append
$OutFile = $output = "c:\temp\gmembers.txt"
$MyList=get-content "c:\nameofdlgroups.csv" |get-distributiongroup | select displayname -expandproperty managedby | select displayname,name
output = `
foreach($MyItem in $MyList){
if ($MyprevItem -ne $MyItem.DisplayName){
$MyItem.DisplayName
" $($MyItem.Name)"
$MyprevItem=$MyItem.Displa
} else{
" $($MyItem.Name)"
}
}
$Output | Out-File $OutFile -Append
ASKER