PowerShell Restart Servers Script

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.
Kelly GarciaSenior Systems AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan CraciunIT ConsultantCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dan CraciunIT ConsultantCommented:
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

0
Kelly GarciaSenior Systems AdministratorAuthor 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?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Kelly GarciaSenior Systems AdministratorAuthor Commented:
Also is there a way to check if there are any users logged in?
0
Dan CraciunIT ConsultantCommented:
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.
0
Dan CraciunIT ConsultantCommented:
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
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
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.
0
Kelly GarciaSenior Systems AdministratorAuthor 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?
0
Kelly GarciaSenior Systems AdministratorAuthor 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.
0
Dan CraciunIT ConsultantCommented:
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
0
Kelly GarciaSenior Systems AdministratorAuthor Commented:
Hi it don't seem to read the if (!(Test-Connection -ComputerName $i -Quiet))

instead it sends me the email. Please Help!
0
Kelly GarciaSenior Systems AdministratorAuthor 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??
0
Dan CraciunIT ConsultantCommented:
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.
0
footechCommented:
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.
0
Kelly GarciaSenior Systems AdministratorAuthor 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.
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
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.
0
Kelly GarciaSenior Systems AdministratorAuthor Commented:
thank you all much appreciated!
0
Kelly GarciaSenior Systems AdministratorAuthor 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?
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
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

0
Kelly GarciaSenior Systems AdministratorAuthor 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.
0
Kelly GarciaSenior Systems AdministratorAuthor Commented:
How can I get around the get-credential issue, where I can store this data so it wont prompt?
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You want to store the credentials, or to get asked locally instead of remote?
0
Kelly GarciaSenior Systems AdministratorAuthor Commented:
store credentials, so when I use windows task scheduler I wont get prompted for it, hope it makes sense.
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Is having the password in plain text in the script ok, or do you need better security?
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
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

0
Kelly GarciaSenior Systems AdministratorAuthor Commented:
how would I reimport the password file in the get-credential? or anywhere else where it requires user names and password?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.