Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
2 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Running test-servicehealth from Excel list
Posted on 2011-03-19
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
The test-servicehealth cmdlet has a -server parameter, so you can use the following structure to make the test from any Exchange box or workstation that has the Exchange Management Tools installed. I recommend to put the serverlist into a TXT file or a CSV. Reading directly from an XLS is more complicated.
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.
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.
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.)
Featured Post
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| SMTP Receive connector logging | 1 | 46 | |
| run powershell script endlessly | 3 | 32 | |
| Where do I find the default retention policy installed with Exchange Server 2010? | 2 | 16 | |
| How to adjust Office 365 spam & junk email settings | 4 | 23 |
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
In-place Upgrading Dirsync to Azure AD Connect
In this video we show how to create an Address List 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 Organization >> Ad…
The video tutorial explains the basics of the Exchange server Database Availability groups.
The components of this video include:
1. Automatic Failover
2. Failover Clustering
3. Active Manager
Suggested Courses
Course of the Month2 days, 5 hours left to enroll
710 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.