Skip to content

Instantly share code, notes, and snippets.

View workstg's full-sized avatar

WORKSLAB workstg

  • Saitama, Japan
View GitHub Profile
# To prevent malfunction
Param ([alias("-remove","r")][switch]$RemFrag)
$KeepAppxPackages = @(
"Microsoft.WindowsCalculator",
"Microsoft.ScreenSketch"
)
Write-Output "Start scripts."
# Remove Privisioned Appx Packages
@workstg
workstg / check-old-records.sql
Created November 6, 2022 06:53
Purging old data from the Horizon Events Database (2150309)
USE HVEVENT;
DECLARE @OLD_DAY INT = -30
SELECT COUNT(*) FROM [dbo].[hv_event_data_historical]
WHERE EventID
IN (
SELECT EventID FROM [dbo].[hv_event_historical] WHERE Time < (DATEADD(day, @OLD_DAY, GETDATE()))
);
SELECT COUNT(*) FROM [dbo].[hv_event_historical]
WHERE Time < (DATEADD(day, @OLD_DAY, GETDATE()));
@workstg
workstg / GetArpTables.ps1
Created August 21, 2022 23:51
Executing "arp -a" on remote hosts.
# Parameters
$HostFile = $PSScriptRoot + "\hosts.txt"
$LogFolder = $PSScriptRoot + "\logs"
# Credential
$Credential = Get-Credential
#$SecureString = ConvertTo-SecureString "Password" -AsPlainText -Force
#$Credential = New-Object System.Management.Automation.PsCredential "DOMAIN\Administrator", $SecureString
# Import hosts list
@workstg
workstg / GetArpTable.ps1
Created February 18, 2022 12:27
Get arp tables from remote host.
# Parameters
$HostFile = $PSScriptRoot + "\hosts.txt"
$LogFolder = $PSScriptRoot + "\logs"
# Main Routine
$Credential = Get-Credential
$HostList = Get-Content $HostFile
if (!(Test-Path $LogFolder)) {
@workstg
workstg / RemoveTempFiles.ps1
Created February 8, 2022 14:45
一時ファイルや不要な隠しファイルを削除する
Get-ChildItem $Args[0] -Force -Recurse | ? {
$_.Name -like "~*" -and $_.LastWriteTime -lt (Get-Date).AddDays(-1) `
-or $_.Name -like "*.tmp" `
-or $_.Name -like "._*" `
-or $_.Name -eq "Thumbs.db" `
-or $_.Name -eq ".DS_Store" `
} | Remove-Item -Force
exit
@workstg
workstg / TimeoutBreaker.ps1
Created February 8, 2022 14:43
定期的にScrollLockを入力する
function Get-ConsoleWindowHandle {
$Proc = Get-Process -Id $PID
$i = 0
while ($Proc.MainWindowHandle -eq 0) {
if ($i++ -gt 10) {
return $null
}
$Proc = $Proc.Parent
}
return $Proc.MainWindowHandle
@workstg
workstg / Remote-Execute.vbs
Created December 15, 2021 14:13
Run a process on a remote computer.
Dim objLocator, objConn, objProc
Dim tmpRet, intPid, TargetHost, TargetUser, TargetPass
TargetHost = Wscript.Arguments(0)
TargetUser = Wscript.Arguments(1)
TargetPass = Wscript.Arguments(2)
WScript.Echo TargetHost & " --- "
Set objLocator = WScript.CreateObject("WbemScripting.SWbemLocator")
Set objConn = objLocator.ConnectServer(Targethost, "root\cimv2", TargetUser, TargetPass)
@workstg
workstg / ExportDefaultPrinterSettings.bat
Last active December 16, 2020 12:03
既定のプリンター設定を設定をファイルへエクスポート/インポートするバッチファイル
@ECHO OFF
SET REGFILE=%USERPROFILE%\default-printer.reg
REG EXPORT "HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows" %REGFILE% /y
EXIT
@workstg
workstg / EvacuateDefaultPrinterSettings.ps1
Last active December 15, 2020 14:03
既定のプリンター設定をレジストリ内で待避/復元するPowerShellスクリプト
# [通常使うプリンター]のエントリ退避
$RegkeyTemp = "HKCU:\PrinterTemp"
$RegkeyWinNt = "HKCU:\Software\Microsoft\Windows NT\CurrentVersion\Windows"
if (!(Test-Path -LiteralPath $RegKeyTemp)) {
New-Item $RegkeyTemp
}
Copy-ItemProperty -LiteralPath $RegKeyWinNt -Name "Device" -Destination $RegKeyTemp
@workstg
workstg / EvacuateDefaultPrinterSettings.bat
Created December 15, 2020 13:45
既定のプリンター設定をレジストリ内で待避/復元するバッチファイル
@ECHO OFF
SET TEMPKEY="HKCU\PrinterTemp"
REG QUERY %TEMPKEY%
IF ERRORLEVEL 1 goto SETKEY
IF ERRORLEVEL 0 goto COPYVAL
:SETKEY
REG ADD %TEMPKEY%