PowerShell Restart Servers Script

Kelly Garcia
Kelly Garcia used Ask the Experts™
on
Hi Guys,

I have have this server restart script:

$header = "server"
 
$servers = import-csv c:\path\to\ServersToReboot.csv -header $header
 
foreach($i in $servers) {
     Write-Host "Attempting to reboot:" $i.server "..."
 
     $serverObj = gwmi Win32_operatingsystem -computer $i.server
 
     $status = $serverObj.reboot()
 
     if ($status.ReturnValue = "0") {
          Write-Host "Reboot successful."
     } else {
          Write-Host "Reboot failed. Check permissions."
     }
}

However I need to reboot servers one at time, when one server comes back up then to reboot the next one, how can I do this?

Please help!

Thank you in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
The simplest way would be to add a pause
foreach($i in $servers) {
     Write-Host "Attempting to reboot:" $i.server "..."
 
     $serverObj = gwmi Win32_operatingsystem -computer $i.server
 
     $status = $serverObj.reboot()
 
     if ($status.ReturnValue = "0") {
          Write-Host "Reboot successful."
     } else {
          Write-Host "Reboot failed. Check permissions."
     }
    Start-Sleep -s 600  # this will wait for 10 minutes
}

Open in new window

HTH,
Dan

Commented:
Or, you can check network connectivity to the server, once every 5 seconds:
foreach($i in $servers) {
     Write-Host "Attempting to reboot:" $i.server "..."
 
     $serverObj = gwmi Win32_operatingsystem -computer $i.server
 
     $status = $serverObj.reboot()
 
     if ($status.ReturnValue = "0") {
          Write-Host "Reboot successful."
     } else {
          Write-Host "Reboot failed. Check permissions."
     }
    do {
        Start-Sleep -s 5  # this will wait for 5 seconds }
    while (!(Test-Connection -ComputerName $i -Quiet))
}

Open in new window

Kelly GarciaSenior Systems Administrator

Author

Commented:
thanks Dan, Problem is that I need confirmation that my server is back online sometimes on my network the VM doesn't pick up an ip address so it requires another reboot.

If there was a way to ping the server to see that its back online, if it is then to continue the loop of restarting the other servers, hope this makes sense.

what does the -quite switch mean?
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

Kelly GarciaSenior Systems Administrator

Author

Commented:
Also is there a way to check if there are any users logged in?

Commented:
Test-Connection pings the server :)

See here: http://technet.microsoft.com/en-us/library/hh849808.aspx

-Quiet will disable output and simply return True if the ping succeeded and False if not.

So this:
while (!(Test-Connection -ComputerName $i -Quiet))
will be true as long as the $i server does not anwer the ping. ! negates.
Commented:
The simplest way I know of to check for logged-on users is
Get-TSSession -ComputerName $i

You need the Terminal Services PowerShell Module, which you can get from here: http://archive.msdn.microsoft.com/PSTerminalServices

After install, you would do:
Import-Module PSTerminalServices
Get-TSSession -ComputerName "yourServer"

Open in new window

HTH,
Dan
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
The only way to check for a VM starting, but not getting an IP, is to use the respective VM PS tools, like VMware PowerCLI. Without an IP the remote machine is not reachable otherwise.
Kelly GarciaSenior Systems Administrator

Author

Commented:
thanks dan much appreciated, what I am thinking is to send an email for servers that fail the ping :)

So is the while (!(Test-Connection -ComputerName $i -Quiet)) only once inside the for loop, ow will it continue sending me emails until its back up?
Kelly GarciaSenior Systems Administrator

Author

Commented:
Hi Dan,

that's my script so far will it work?

$header = "server"
 
$servers = import-csv c:\servers.csv -header $header

foreach($i in $servers) {
     Write-Host "Attempting to reboot:" $i.server "..."
 
     $serverObj = gwmi Win32_operatingsystem -computer $i.server
 
     $status = $serverObj.reboot()
 
     if ($status.ReturnValue = "0") {
          Write-Host "Reboot successful."
	Start-Sleep -s 300  # this will wait for 5 minutes
     } else {
          Write-Host "Reboot failed. Check permissions."
     }
    do {

	Send-MailMessage -To "test.test@test.ac.uk" -From "test@test.ac.uk" -SmtpServer 192.168.100.31 -Subject "$i ping failed" -Body "$i ping failed"	

        }
    while (!(Test-Connection -ComputerName $i -Quiet))
}

Open in new window


The idea is to reboot a server, then wait 5 minutes and then do a ping If that fails it will send us an email saying it failed and then continue rebooting the other servers.

Thank you soo much dan.
Commented:
You don't need a loop, or you'll end up with a full inbox if a server does not start.

Replace
  do {

	Send-MailMessage -To "test.test@test.ac.uk" -From "test@test.ac.uk" -SmtpServer 192.168.100.31 -Subject "$i ping failed" -Body "$i ping failed"	

        }
    while (!(Test-Connection -ComputerName $i -Quiet))

Open in new window


with
if (!(Test-Connection -ComputerName $i -Quiet)) {
    Send-MailMessage -To "test.test@test.ac.uk" -From "test@test.ac.uk" -SmtpServer 192.168.100.31 -Subject "$i ping failed" -Body "$i ping failed"
}

Open in new window

HTH,
Dan
Kelly GarciaSenior Systems Administrator

Author

Commented:
Hi it don't seem to read the if (!(Test-Connection -ComputerName $i -Quiet))

instead it sends me the email. Please Help!
Kelly GarciaSenior Systems Administrator

Author

Commented:
I've tried

if (Test-Connection -ComputerName $i -Quiet)
	{
    		Send-MailMessage -To "test@test.ac.uk" -From "test@test.ac.uk" -SmtpServer smtp.test.ac.uk -Subject "$i ping successful" -Body "$i ping successful"
	} 
	Else
		{

			Send-MailMessage -To "test@test.ac.uk" -From "test@test.ac.uk" -SmtpServer smtp.test.ac.uk -Subject "$i ping Failed" -Body "$i ping Failed"
		}

Open in new window


However for some reason it sends the email from the else statement?? even if the condition is true??

Commented:
Nope.
If it always sends the message from the Else statement, that means the condition is false.

Test the condition in PS and see if it works. Remove the -Quiet to see the output and errors.
I'm suspecting that $i does not resolve properly. DNS trouble.
Top Expert 2014
Commented:
Given the earlier part of your script, the test-connection command probably needs to be
if (Test-Connection -ComputerName $i.server -Quiet)

I'm curious why you don't just use the Restart-Computer cmdlet.  It has parameters to wait for specified resources to be available, timeout, etc.
Kelly GarciaSenior Systems Administrator

Author

Commented:
good question footech, I never knew about the restart-computer cmdlet! please let me know how I can use it for my purpose, its not just about the script its also about learning powershell.

Many thanks guys, I will give it the best grade I can when I close it.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
If you don't know anything about a cmdlet, or search for what could be fitting, use get-help or get-command with wildcards. E.g. for this case you can try:
 Get-Help restart-*
and you get at least two cmdlets (restart-computer and restart-service).
After you've spotted the probably correct cmdlet, get specific and detailed help with
 Get-Help -full restart-computer
Depending on your PS release (2.0 or 3.0), you get different syntax. 3.0 allows for more options, like waiting for completion, timeout etc.
Kelly GarciaSenior Systems Administrator

Author

Commented:
thank you all much appreciated!
Kelly GarciaSenior Systems Administrator

Author

Commented:
Hi Guys,

I am trying to link the script that restarts the servers to another script to test the connection and restart the VM's using power cli, so far this is what I have written:

Add-PSSnapin VMware.VimAutomation.Core
$cred=get-credential
Connect-VIServer 10.2.32.4 –Credential $cred


Get-Content C:\Reboot_Servers.csv| % { if (!(Test-Connection -ComputerName $_ -Quiet))

$vm=get-vm "*" + $_ + "*"
Restart-VM -VM $VM
Start-Sleep -s 300  # this will wait for 5 minutes
   }

Open in new window


 and it needs to be run on another server with powercli installed, problem is that I wont be sitting on the computer when this command runs and the get-credential will prompt for credential and also how can I link this with my other script, restart server script?
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Live is much easier if you install PowerCLI on the machine you want to run the script on.
And I have no idea how you would want to link the scripts - they have no connection to each other. However, you can always just call another script within a script by providing the path:
<# code here #>
C:\Scripts\otherScript.ps1

Open in new window

Kelly GarciaSenior Systems Administrator

Author

Commented:
thanks Qlemo, yea its a lot better I can install powercli on the server, but problem is it has to go through a lengthy change request at my organisation.
Kelly GarciaSenior Systems Administrator

Author

Commented:
How can I get around the get-credential issue, where I can store this data so it wont prompt?
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
You want to store the credentials, or to get asked locally instead of remote?
Kelly GarciaSenior Systems Administrator

Author

Commented:
store credentials, so when I use windows task scheduler I wont get prompted for it, hope it makes sense.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Is having the password in plain text in the script ok, or do you need better security?
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Plain text:
$cred = New-Object Management.Automation.PsCredential("Username",
  (ConvertTo-SecureString "Password" -AsPlainText -force))

Open in new window

Password hashed in a file:
$cred = New-Object Management.Automation.PsCredential("Username",
  (Get-Content C:\Passwordfile.txt | ConvertTo-SecureString))

Open in new window

and the file has been generated once with
Read-Host -AsSecureString | ConvertFrom-SecureString | Out-File C:\Passwordfile.txt

Open in new window

(to get a prompt) or
ConvertTo-SecureString "Password" -AsPlainText -Force | ConvertFrom-SecureString | Out-File C:\Passwordfile.txt

Open in new window

Kelly GarciaSenior Systems Administrator

Author

Commented:
how would I reimport the password file in the get-credential? or anywhere else where it requires user names and password?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial