This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi all.
I've been trying to merge two scripts but I'm having problems and I need some help...
I need to export specific information of my tenants mailboxes into a single CSV file but some information comes up empty on the CSV file cells and I found out that I need to use a different script to get that information, I tried to merge the two scripts but with no success and I've tried to use the "- Append" parameter to add the second script results on to the same CSV file but also with no success.
This is the first script:
Get-Mailbox -ResultSize Unlimited | Select-Object AddressBookPolicy, ProhibitSendQuota, SamAccountName, UserPrincipalName, WhenMailboxCreated, Alias, OrganizationalUnit, CustomAttribute1, DisplayName, PrimarySmtpAddress, RecipientType, RecipientTypeDetails, WindowsEmailAddress, WhenChanged, WhenCreated | export-csv -NoTypeInformation .\Mailboxes_filtered.csv -Delimiter ";" -Encoding unicode
And this is the second:
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select DisplayName, StorageLimitStatus, TotalItemSize |export-csv -NoTypeInformation .\Mailboxes_filtered.csv -Delimiter ";" -Encoding unicode
If I try to add the second script objects into the first script, the respective cells on the CSV come up empty (except "DisplayName") and if I try to use all objects in the second script, only those three above won't show up empty on the CSV file.
So what I really need is to merge or combine this two scripts into just one (or append the second script results into the same CSV file). I allready found out ways on this forum on how to resolve this issue but the solution is done with severall scripts and command lines using variables to store results but that won't work for me...what I really need is to get the information I need with just one script so it can be practical to use, after that I can organize the exported info on a Excel datasheet.
Thanks in advance!
You could merge them into one as below:
$Mailboxes = Get-Mailbox -RecipientTypeDetail UserMailbox -ResultSize Unlimited
$Data = @()
foreach($Mailbox in $Mailboxes){
$temp = Get-Mailbox $Mailbox.PrimarySmtpAddress.Address | Select-Object AddressBookPolicy, ProhibitSendQuota, SamAccountName, UserPrincipalName, WhenMailboxCreated, Alias, OrganizationalUnit, CustomAttribute1, DisplayName, PrimarySmtpAddress, RecipientType, RecipientTypeDetails, WindowsEmailAddress, WhenChanged, WhenCreated,StorageLimitStatus, TotalItemSize
$temp.StorageLimitStatus = (Get-MailboxStatistics $Mailbox.PrimarySmtpAddress.Address).StorageLimitStatus
$temp.TotalItemSize = (Get-MailboxStatistics $Mailbox.PrimarySmtpAddress.Address).TotalItemSize.Value
$data+=$temp
}$data | export-csv c:/temp/log.csv -NoTypeInformation
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Well, I tried to put that scrip on a TXT file and renamed it with a ".ps1" extension but it's not working, it generates a lot of errors....
Meanwhile I tried to find a way to merge those three objects from the second script into the created CSV file (delimited by ";") and I managed to get some success using:
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName,StorageLimitStatus,TotalItemSize | Add-Content -Path .\Mailboxes_filtered.csv
I managed to add the info from those objects in the delimited CSV but because I can't use the -Delimiter ";" parameter, that info shows up under the other instead showing up aside...I was also trying to use the -Append parameter but got stuck with the same problem....
I took a look at your script and I saw that the $Mailbox string wasn't declared and the $Data string declared at the begining, later shows up as $data...won't that raise some problems?
Anyway, I thought maybe it would be easier to append the second script results to the created delimited CSV rather than storing all values on strings to generate the complete file....what do you think?
And thanks for the help, it has been a while since I did some code, these days I'm more on the Networking area...
The truth is that I have two scripts that work but I'm not beeing able to merge the results on the same delimited CSV and I really need a solution....
What is the error when you run it?
It could run correctly in my lab: (I remove the "| export-csv c:/temp/log.csv -NoTypeInformation" for print the result to the screen directly)
The warning is caused by mailbox never used after being created.
This is what I'm getting:
Ok, let take step below to check which formart for PrimarySmtpAddress in your organization:
(Get-Mailbox testuser).PrimarySmtpAddress.Address
(Get-Mailbox testuser).PrimarySmtpAddress
Check which one could find the correct PrimarySmtpAddress for this mailbox in your organization.
Here is the source file, I would suggest you run directly 256692-demo.txt
Hi.
Sorry for the late response, I had to focus on other issues.
I've tested both commands and only the second returned the value (I also tried to switch that command in the script by removing ".Address" on the existing ones but I still got lots of errors....)
@KyleXu-MSFT , Hi there again.
Just to say that I already have the solution, I had a little help but finally I have a working script...it seemed that the problem was really in the PrimarySmtpAddress object.
Here's the script:
$mailboxlist = Get-Mailbox -ResultSize Unlimited | Select-Object AddressBookPolicy, ProhibitSendQuota, SamAccountName, UserPrincipalName, WhenMailboxCreated, Alias, OrganizationalUnit, CustomAttribute1, DisplayName, PrimarySmtpAddress, RecipientType, RecipientTypeDetails, WindowsEmailAddress, WhenChanged, WhenCreated
$results = foreach($mailbox in $mailboxlist){
$stats = Get-MailboxStatistics -Identity $mailbox.UserPrincipalName | Select StorageLimitStatus, TotalItemSize
$mailbox | Select-Object *, @{n='StorageLimitStatus';e={$stats.StorageLimitStatus}}, @{n='TotalItemSize';e={$stats.TotalItemSize}}
}
$results | Export-Csv -NoTypeInformation .\Mailboxes_filtered.csv -Delimiter ";" -Encoding unicode
I hope it can help others too, and thanks so much for your help anyway!
Gald to see it is solved. Due to the forum policy, the question author cannot accept their own answer. They can only accept answers by others. Could I merge it to my answer, then accept it as an answer to close this thread. It also could be beneficial to other community members reading this thread.
Sure, no problem. Go ahead.
I have merged them, thanks for your help.
It's done, I've accepted the answer. And I should be the one giving thanks, if you hadn't point out the PrimarySmtpAddress issue, I wouldn't have reached to a solution, so...thanks so much for your help!