Hi

how do i get the storagegroupcopystatus of two servers and email the results? i do know that using EMS i can get the status of the two servers and output them on the screen by simply doing:

get-storagegroupcopystatus -identity "EXCH\SG1" -StandbyMachine EXCH2

get-storagegroupcopystatus -identity "EXCH2\SG1 -standbyMachine EXCH

and save them as .ps1

how do i make the output to a file for both of the commands and send the output via email?

i know its probably an easy solution but i am new with this things.

thanks

khiko

You are right, it's not hard at all. Just pipe your command to set-content and provide a filename. This applies to any object (which can be represented as a string) with PowerShell, not just storage group stuff. e.g.:

get-storagegroupcopystatus -identity "EXCH2\SG1 -standbyMachine EXCH | set-content filename.txt

One thing to watch out for with set-content is the default text encoding is Unicode (double-byte) so the text file is double the size. Use "set-content -encoding ascii" to override.

And there's add-content for appending.

Alternately, you can work in memory without writing anything to a file. e.g.:

$a = get-storagegroupcopystatus -identity "EXCH2\SG1 -standbyMachine EXCH
$a += get-storagegroupcopystatus -identity "EXCH\SG1" -StandbyMachine EXCH2
$a | { some commands here to send the email }

I'd help with the mail sending part but I don't actually use Exchange. :) I can point you to a few non-Exchange ways but I'll just let someone else give the answer you need instead.

got what i want i think...

$FromAddress = "senderemail"
$ToAddress = "recipientemail"
$MessageSubject = "messagesubject"
$MessageBody = "messagebody"
$SendingServer = "smtpserver"

get-storagegroupcopystatus -identity "EXCH1\SG1" -StandbyMachine EXCH2 | Select Identity,SummaryCopyStatus,LastInspectedLogTime | Out-File filename.txt
get-storagegroupcopystatus -identity "EXCH2\First Storage Group" -StandbyMachine EXCH1 |Select Identity,SummaryCopyStatus,LastInspectedLogTime | Out-File filename.txt -append

$SMTPMessage = New-Object System.Net.Mail.MailMessage $FromAddress, $ToAddress,
$MessageSubject, $MessageBody
$Attachment = New-Object Net.Mail.Attachment("./filename.txt")
$SMTPMessage.Attachments.Add($Attachment)

$SMTPClient = New-Object System.Net.Mail.SMTPClient $SendingServer
$SMTPClient.Send($SMTPMessage)

results is below

Identity                            SummaryCopyStatus LastInspectedLogTime    
--------                            ----------------- --------------------    
EXCH1\SG1                    Healthy                         

Identity                            SummaryCopyStatus LastInspectedLogTime    
--------                            ----------------- --------------------    
EXCH2\SG1                    Healthy                         

thanks for your help. i also got some of it from sendmailboxstatus script which i got from another website i think (credit to them)

i think there are more ways to improve the output...

Sure. Leave off the two lines which create an attachment object and assign content to it.

$Attachment = New-Object Net.Mail.Attachment("./filename.txt")
$SMTPMessage.Attachments.Add($Attachment)

And above that in line 4, do something like this:

$MessageBody = get-content ./filename.txt

thanks! i will try this tomorrow as i am home right now :)

------

tried it, and it works. but the scripts need to be re ordered in order for the get-content to work as it is looking for the output file.

only thing is the message body doesnt look good. probably need to use tables?