WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!
Running test-servicehealth from Excel list
Hi
I have a list of 20 Exchange 2007 servers in Excel that are going to be rebooted this evening.
I would like to run test-servicehealth and test-mapiconnectivity against them tomorrow morning. Rather than typing each one out manually, I'd like Powershell to be able to grab them from the Excel sheet and run through each one.
Does anyone know how I would do this?
I have a list of 20 Exchange 2007 servers in Excel that are going to be rebooted this evening.
I would like to run test-servicehealth and test-mapiconnectivity against them tomorrow morning. Rather than typing each one out manually, I'd like Powershell to be able to grab them from the Excel sheet and run through each one.
Does anyone know how I would do this?
Asked:
Who is Participating?
That's great, thanks very much.
For this: get-content c:\serverlist.txt | foreach-object {test-servicehealth -server $_}
I can see the servers and the results of test-servicehealth, but is there any way to return the name of the servers too, so if there is a failure on one I know which one it is?
For this: get-content c:\serverlist.txt | foreach-object {test-servicehealth -server $_}
I can see the servers and the results of test-servicehealth, but is there any way to return the name of the servers too, so if there is a failure on one I know which one it is?
Unfortunately I have only Exchange 2010, so I can not check, if the result will be OK for Exchange 2007, but here is my try:
get-content c:\serverlist.txt | foreach-object {$s = $_; test-servicehealth -server $s | select-object -property *, @{n="Server";e={$s}}}
get-content c:\serverlist.txt | foreach-object {$s = $_; test-servicehealth -server $s | select-object -property *, @{n="Server";e={$s}}}
You can direct feed the Exchange servers without the server with the below command.
Get-ExchangeServer | Test-ServiceHealth
Would have to check how we get the name of the servers though....this will only give you the role of the server.
- Habz
Get-ExchangeServer | Test-ServiceHealth
Would have to check how we get the name of the servers though....this will only give you the role of the server.
- Habz
Thanks both
As regards this line here:
get-content c:\serverlist.txt | foreach-object {$s = $_; test-servicehealth -server $s | select-object -property *, @{n="Server";e={$s}}}
Isn't there an easier way to get the name of the server than this? Surely a get-server somewhere in there would work?
As regards this line here:
get-content c:\serverlist.txt | foreach-object {$s = $_; test-servicehealth -server $s | select-object -property *, @{n="Server";e={$s}}}
Isn't there an easier way to get the name of the server than this? Surely a get-server somewhere in there would work?
Check if the output of
test-servicehealth -server $s | fl *
includes any line, with the servername in it. If not, there is no easier way to do. (In Exchange 2010 the servrename is there.)
test-servicehealth -server $s | fl *
includes any line, with the servername in it. If not, there is no easier way to do. (In Exchange 2010 the servrename is there.)
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month6 days, 11 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
get-content c:\serverlist.txt | foreach-object {test-servicehealth -server $_}
Of course you can customize the test-searvicehealth part accourding to your needs.
The test-mapiconnectivity requires databases or mailboxes as an input to test:
get-content c:\databases.txt | foreach-object {test-mapiconnectivity -database $_}
or
get-content c:\mailboxestotest.txt | foreach-object {test-mapiconnectivity -identity $_}
Of course, here you have to customize the rest of the test-mapiconnectivity part accourding to your needs.