2018. 10. 27. 22:44
Powershell
'Powershell' 카테고리의 다른 글
| AD계정 정보 가져오기 (0) | 2018.12.26 |
|---|---|
| TCP 소켓 통신 예제 (0) | 2018.10.27 |
| 로컬( local)계정 생성후 Administrator 그룹에 넣기 (0) | 2018.10.27 |
| Powershell 외부서버의 스크립트 실행하기 (0) | 2018.05.25 |
2018. 10. 27. 22:42
Powershell
#Socket Serverfunction listen-port ($port= 7788) { $SEND_SMS = "0000" $endpoint = new-object System.Net.IPEndPoint ([ system.net.ipaddress]::any , $port ) $listener = new-object System.Net.Sockets.TcpListener $endpoint $listener.start() $isRunning = $true while ($isRunning ) { $client = $listener. AcceptTcpClient() # will block here until connection $stream = $client. GetStream(); $reader = New-Object System.IO.StreamReader $stream #$command = $reader.readLine().Substring(0, 4); $command = $reader. readLine() -split "//" $command.Length #$command = $reader.readLine() if ($command -eq $SEND_SMS) { sendSMS -serverIP $command[ 2] -phoneArray $command [1] } else { write-host $command -fore cyan } if($command [0] -eq "EXIT") { $isRunning = $false $reader.Dispose() $stream.Dispose() $client.Dispose() $listener.stop() } } <# $reader.Dispose() $stream.Dispose() $client.Dispose() $listener.stop() #>}function sendSMS ($serverIP, $phoneArray){ $targetArray = $phoneArray -split "," foreach($phone in $targetArray) { Write-Host "SMS SEND" $phone "`t`t" $serverIP }}listen-port#client code<#function send-msg ($message=$([char]4), $port=7788, $server="10.100.37.79") { $client = New-Object System.Net.Sockets.TcpClient $server, $port $stream = $client.GetStream() $writer = New-Object System.IO.StreamWriter $stream $writer.Write($message) $writer.Dispose() $stream.Dispose() $client.Dispose()}#>
'Powershell' 카테고리의 다른 글
| AD계정 정보 가져오기 (0) | 2018.12.26 |
|---|---|
| Powershell 방화벽 관리하기 (0) | 2018.10.27 |
| 로컬( local)계정 생성후 Administrator 그룹에 넣기 (0) | 2018.10.27 |
| Powershell 외부서버의 스크립트 실행하기 (0) | 2018.05.25 |
2018. 10. 27. 22:41
SQL SERVER
SELECT 'CREATE LOGIN ' +name + ' WITH PASSWORD = ' + CONVERT(varchar (max), LOGINPROPERTY( name, 'PasswordHash'), 1 ) + ' HASHED, SID=' + CONVERT( varchar(max ), sid , 1) FROM sys .server_principalsWHERE name in ('drm_dev', 'MyLogin2') AND type = 'S'
'SQL SERVER' 카테고리의 다른 글
| SQL SERVER Wait type 조사 (0) | 2018.10.27 |
|---|---|
| DAC 연결방법 (0) | 2018.10.27 |
| CPU 사용율 높은 쿼리 확인 (0) | 2018.10.27 |
| tempdb 경합 모니터링 (0) | 2018.10.27 |
| SQL SERVER 로그 정보(사용량, usage) (0) | 2018.10.27 |