Skip to content

Instantly share code, notes, and snippets.

@belotn
Last active December 13, 2015 22:48
Show Gist options
  • Save belotn/4986539 to your computer and use it in GitHub Desktop.
Save belotn/4986539 to your computer and use it in GitHub Desktop.
Change datastore configuration on all farm servers
$username ="MyUser"
$password="MyPwd"
$dsnfilename="Path/to/my/newdsn"
Get-xaserver |% {
$serverName = $_.servername
$servername
get-content New.dsn |%{ if ($_ -like '*WSID*') {"WSID=$servername" }else{$_} } | out-file "\\$($_.ServerNAme)\c$\Path\to\newdsn"
$command = "cmd /c dsmaint config /user:$username /pwd:$password /dsn:$dsnfilename > c:\dsm_config.log"
$process = [WMICLASS]"\\$serverName\ROOT\CIMV2:win32_process"
$result = $process.Create($command)
Start-Sleep -seconds 10
"Arret dépendant"
$depsvc = Get-Service -ComputerName $serverName -name IMAService -dependentservices | Select -Property Name
$depsvc | %{
$svc = Get-Service -ComputerName $serverName -name $_.Name
$svc.Stop()
while($svc.status -ne "Stopped"){
$svc = Get-Service -ComputerName $serverName -name $svc.NAme
Start-Sleep -seconds 1
}
}
"Arret IMA"
$service = Get-Service -ComputerName $serverName -name IMAService
$service.stop()
while($service.status -ne "Stopped"){
$service = Get-Service -ComputerName $serverName -name IMAService
Start-Sleep -seconds 1
}
"Relance IMA"
$service.start()
while($service.status -ne "Running"){
$service = Get-Service -ComputerName $serverName -name IMAService
Start-Sleep -seconds 1
}
"Relance dependant"
$depsvc | %{
$svc = Get-Service -ComputerName $serverName -name $_.Name
$svc.Start()
while($svc.status -ne "Running"){
$svc = Get-Service -ComputerName $serverName -name $svc.NAme
Start-Sleep -seconds 1
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment