Monday, March 26, 2018

Powershell скрипт для ускорения настройки 1С

Get-NetFirewallRule -DisplayName "Remote Desktop*" | Set-NetFirewallRule -enabled true
Get-NetFirewallRule -DisplayName "Удаленный рабочий стол*" | Set-NetFirewallRule -enabled true


$firewallRuleMSSQL = Get-NetFirewallRule -DisplayName 'MS SQL'
if (-Not $firewallRuleMSSQL)
{New-NetFirewallRule -DisplayName 'MS SQL' -Enabled true -LocalPort 1433 -Profile DOMAIN -Protocol TCP}

$firewallRuleragent = Get-NetFirewallRule -DisplayName 'ragent.exe'
if (-Not $firewallRuleragent)
{New-NetFirewallRule -DisplayName 'ragent.exe' -Enabled true -Program "c:\Program Files\1cv8\8.3.10.2561\bin\ragent.exe" -Profile DOMAIN}

$firewallRulermngr = Get-NetFirewallRule -DisplayName 'rmngr.exe'
if (-Not $firewallRulermngr)
{New-NetFirewallRule -DisplayName 'rmngr.exe' -Enabled true -Program "c:\Program Files\1cv8\8.3.10.2561\bin\rmngr.exe" -Profile DOMAIN}

$firewallRulerphost = Get-NetFirewallRule -DisplayName 'rphost.exe'
if (-Not $firewallRulerphost)
{New-NetFirewallRule -DisplayName 'rphost.exe' -Enabled true -Program "c:\Program Files\1cv8\8.3.10.2561\bin\rphost.exe" -Profile DOMAIN}

Add-LocalGroupMember -Group "Администраторы" -Member "kt\1Cv8", "kt\SystemVeeam"

#Прописываем зависимость sql от виртуального диска
$REGMSSQL = Get-ItemProperty -Path HKLM:\SYSTEM\ControlSet001\Services\MSSQLSERVER -name DependOnService
if (-Not $REGMSSQL)
{New-ItemProperty -Path "HKLM:\SYSTEM\ControlSet001\Services\MSSQLSERVER" -Name "DependOnService" -value "SPVVEngine" -PropertyType MultiString}
else
{Set-ItemProperty -Path "HKLM:\SYSTEM\ControlSet001\Services\MSSQLSERVER" -Name "DependOnService" -Value "SPVVEngine"}

#Прописываем зависимость 1С от скула
$REGMSSQL = Get-ItemProperty -Path "HKLM:\SYSTEM\ControlSet001\Services\1C:Enterprise 8.3 Server Agent (x86-64)" -name DependOnService
if (-Not $REGMSSQL)
{New-ItemProperty -Path "HKLM:\SYSTEM\ControlSet001\Services\1C:Enterprise 8.3 Server Agent (x86-64)" -Name "DependOnService" -value "Tcpip", "Dnscache", "lanmanworkstation", "lanmanserver", "MSSQLSERVER" -PropertyType MultiString}
else
{Set-ItemProperty -Path "HKLM:\SYSTEM\ControlSet001\Services\1C:Enterprise 8.3 Server Agent (x86-64)" -Name "DependOnService" -Value "Tcpip", "Dnscache", "lanmanworkstation", "lanmanserver", "MSSQLSERVER"}