This is a SQL query written in PowerShell. It connects to the SCCM DB and returns Custom_Data for C and D drives.

#import-module sqlps
#Install-Module -Name SqlServer -AllowClobber
#Update-Module -Name SqlServer

Clear-Host

[string] $Server= "SCCM_Server\SQL_Instance"
[string] $Database = "CM_SITENAME"

# C Drive Query
[string] $SQLQuery1 = $("SELECT [Bitlocker_C_Drive00] FROM [dbo].[Custom_Custom_DATA] WHERE MachineID='$ResourceID'")

# D Drive Query
[string] $SQLQuery2 = $("SELECT [Bitlocker_D_Drive00] FROM [dbo].[Custom_Custom_DATA] WHERE MachineID='$ResourceID'")

# Not used at this time - no need to use this if connecting in authorized security context
#[string] $user = "username"
#[string] $pwd = "LetMeIn99$"

$Connection = New-Object System.Data.SQLClient.SQLConnection
$dt = new-object "System.Data.DataTable"

$Connection.ConnectionString = "server='$Server';database='$Database';trusted_connection=true;"
#$Connection.ConnectionString = "server='$Server';uid=$user;pwd=$pwd;database='$Database';trusted_connection=true;"
$Connection.Open()

# C Drive
$cmd1 = $Connection.CreateCommand()
$cmd1.CommandText = $SQLQuery1
$data1 = $cmd1.ExecuteReader()
$dt.Load($data1)
$CDrive = $dt | foreach { $_.Bitlocker_C_Drive00 }
$CDrive

# D Drive
$cmd2 = $Connection.CreateCommand()
$cmd2.CommandText = $SQLQuery2
$data2 = $cmd2.ExecuteReader()
$dt.Load($data2)
$DDrive = $dt | foreach { $_.Bitlocker_D_Drive00 }
$DDrive

# Close Connection
$Connection.Close()

Batch

:: created to change the wireless roaming to medium-high

:: the class - not used, because it may change from model to model
:: {4d36e972-e325-11ce-bfc1-08002be10318}

:: setup
setlocal enabledelayedexpansion
set /a count=1

:: uses dynamic reg scanning to find the right class and subkey
for /f "tokens=1-4 delims= " %%a in ('reg query HKLM\SYSTEM\CurrentControlSet\Control\Class /v RoamAggressiveness /s') do (
:: sets the returned reg key 
if !count!==1 set var1=%%a
set /a count+=1
)

:: applies reg change
reg add "%var1%" /v RoamAggressiveness /t REG_SZ /d 3 /f

exit /b 0

PowerShell

Set-NetAdapterAdvancedProperty -Name "Wi-Fi" -DisplayName "Roaming Aggressiveness" -DisplayValue "4. Medium-High"

This will change the taskbar color from black to blue

reg add “HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Themes\Personalize” /v ColorPrevalence  /t REG_DWORD /d 2 /f

taskkill /f /im explorer.exe
start “” explorer.exe

Screenshot

Methods for uninstalling Chrome

EXE (good)

"C:\Program Files (x86)\Google\Chrome\Application\64.0.3282.140\Installer\setup.exe" --uninstall --multi-install --chrome --system-level --force-uninstall

WMI (meh)

wmic product where “name like ‘Google Chrome'” call uninstall /nointeractive

GUID

MSIEXEC.EXE /X{FE64921C-E29D-39EC-9DD9-C567C6E5A0C6} /qn /norestart

Note, GUIDs can be found

“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\”

“HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\”

Return any version number (better)

c:
cd\Program Files (x86)\Google\Chrome\Application

:: return version number
setlocal enabledelayedexpansion
set version=
set /a count=1
for /f “delims=” %%V in (‘dir “C:\Program Files (x86)\Google\Chrome\Application\” /a:d /b’) do (
if !count!==1 set version=%%V
set /a count+=1
)

“C:\Program Files (x86)\Google\Chrome\Application\%version%\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

:: those are are two hyphens in front of each parameter

Snapshot

As you see, this returns the version. Once you have that, it’s simple to plug that into the command to uninstall Chrome.

Notes

:: DEFAULT BROWSERS
“C:\Program Files (x86)\Google\Chrome\Application\63.0.3282.118\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

“C:\Program Files (x86)\Google\Chrome\Application\63.0.3282.132\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

“C:\Program Files (x86)\Google\Chrome\Application\64.0.3282.119\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

“C:\Program Files (x86)\Google\Chrome\Application\64.0.3282.140\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

“C:\Program Files (x86)\Google\Chrome\Application\64.0.3282.167\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

“C:\Program Files (x86)\Google\Chrome\Application\64.0.3282.168\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

“C:\Program Files (x86)\Google\Chrome\Application\64.0.3282.186\Installer\setup.exe” –uninstall –multi-install –chrome –system-level –force-uninstall

MsiExec.exe /X{141A8DCA-ECB5-3217-B35B-B7F562D65385} /qn /norestart

MsiExec.exe /X{D8BAA38A-97E1-3BD9-A877-673E81553618} /qn /norestart

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{D8BAA38A-97E1-3BD9-A877-673E81553618}” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{141A8DCA-ECB5-3217-B35B-B7F562D65385}” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{FE64921C-E29D-39EC-9DD9-C567C6E5A0C6}” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{D8BAA38A-97E1-3BD9-A877-673E81553618}” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{141A8DCA-ECB5-3217-B35B-B7F562D65385}” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{FE64921C-E29D-39EC-9DD9-C567C6E5A0C6}” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\Google Chrome” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Google Chrome” /f

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Policies\Google\Update” /f
reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Update” /f

:: 63.0.3239.132
:: {141A8DCA-ECB5-3217-B35B-B7F562D65385}

:: 64.0.3239.140
{D8BAA38A-97E1-3BD9-A877-673E81553618}

:: 64.0.3239.119
{FE64921C-E29D-39EC-9DD9-C567C6E5A0C6}

————————————————————————-

:: 57 . 0 . 2987 . 133
:: {8AC8E2E9-87E7-30CA-8308-E737B3911CE5}

:: 58 . 0 . 3029 . 81
:: {A967B385-DA3A-32DD-B6F3-D169E888E661}

:: 58 . 0 . 3029 . 96
:: {A4690197-328E-3732-A460-124D6900D9C5}

:: 58 . 0 . 3029 . 110
:: {ED4B0482-0731-311E-80BB-7D1A87FDF296}

:: 59 . 0 . 3071 . 86
:: {98305915-759E-39B2-A385-5818CDBB9F5B}

:: 59 . 0 . 3071 . 104
:: {BDFAC210-BE15-32E6-BC3D-3CF0E7F4E430}

:: 59 . 0 . 3071 . 115
:: {715E251E-9134-3D1D-BE19-1C6EE18F8D24}

:: 60 . 0 . 3112 . 78
:: {3369F76A-F628-300A-8CC7-53CF96F12C56}

:: 60 . 0 . 3112 . 90
::{3369F76A-F628-300A-8CC7-53CF96F12C56}

:: 60 . 0 . 3112 . 101
:: {60C02A0E-51D2-3127-B4F1-2B92404692AF}

:: 60 . 0 . 3112 . 113
:: {4EC552DD-5454-3B12-A15F-D84ED8DD24D7}

:: 61 . 0 . 3163 . 91
:: {2170A876-572E-31E6-8E5E-157B5EEF508D}

You’ll sometimes notice after upgrading to Windows 10, the settings, the enhanced application settings boxes, will just randomly appear. This is how you disable that odd behavior.

Run these commands from an admin command prompt, or add to a script:

net stop SysMain

sc config SysMain start= disabled

reg add “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\PrefetchParameters” /v “EnableSuperfetch” /t REG_DWORD /d 0 /f

Snapshot

The form…with dropdown selection, buttons, a label, an icon, and transparency.

 
Code

Clear-Host

# Using
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing")
[void][System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
[void][System.Windows.Forms.Application]::EnableVisualStyles()

# Create Form
$Form = New-Object system.Windows.Forms.Form 
$Form.Size = New-Object System.Drawing.Size(400,300) 
#$Form.Width = 400 
#$Form.Height = 300 
$Form.MaximizeBox = $false 
$Form.StartPosition = "CenterScreen" 
$Form.FormBorderStyle = 'Fixed3D' 
$Form.Text = "My Application" 

$Form.AutoSizeMode = "GrowAndShrink"    # or GrowOnly
$Form.MinimizeBox = $False
$Form.MaximizeBox = $False
$Form.WindowState = "Normal"            # Maximized, Minimized, Normal
$Form.SizeGripStyle = "Hide"            # Auto, Hide, Show
$Form.ShowInTaskbar = $True
$Form.Opacity = 0.7                     # 1.0 is fully opaque; 0.0 is invisible
$Form.StartPosition = "CenterScreen"    # CenterScreen, Manual, WindowsDefaultLocation, WindowsDefaultBounds, CenterParent


# Icon
$Icon = New-Object system.drawing.icon ("C:\Program Files (x86)\Microsoft Office\Office15\Groove\ToolIcons\COMPUTER.ICO")
$Form.Icon = $Icon

# Label
$Label = New-Object System.Windows.Forms.Label
$Label.Text = "This form is very simple."
$Label.AutoSize = $True
$Label.Location = New-Object System.Drawing.Size(120,50) 
$Font = New-Object System.Drawing.Font("Calibri",10,[System.Drawing.FontStyle]::Regular) 
$Form.Font = $Font
$Form.Controls.Add($Label)


# Drop Down Selection

# Create datatable to bind a combobox
$datatable = New-Object system.Data.DataTable

# Define Columns
$col1 = New-Object system.Data.DataColumn "Value",([string])
$col2 = New-Object system.Data.DataColumn "Text",([string])


# Add columns to Datatable
$datatable.columns.add($col1)
$datatable.columns.add($col2)
		
# 1 Create Row
$datarow1 = $datatable.NewRow()

# Enter data in row
$datarow1.Value = "Value 1"
$datarow1.Text = "Text 1"

# Add row to datatable
$datatable.Rows.Add($datarow1)


# 2 Create Row
$datarow2 = $datatable.NewRow()

#Enter data in the row
$datarow2.Value = "Value 2"
$datarow2.Text = "Text 2"

# Add the row to the datatable
$datatable.Rows.Add($datarow2)


# 3 Create Row
$datarow3 = $datatable.NewRow()

# Enter Data in row
$datarow3.Value = "Value 3"
$datarow3.Text = "Text 3"

# Add Row to datatable
$datatable.Rows.Add($datarow3)

# Create combobox
$combobox = New-Object System.Windows.Forms.ComboBox		
$combobox.Add_SelectedIndexChanged({
		#output the selected value and text
		write-host $combobox.SelectedItem["Value"] $combobox.SelectedItem["Text"]
})

# Clear Combo before bind
$combobox.Items.Clear()

# Bind Combobox to datatable
$combobox.ValueMember = "Value"
$combobox.DisplayMember = "Text"
$combobox.Datasource = $datatable

# Add Combobox to form
$form.Controls.Add($combobox)	


# Button 1
$Okbutton1 = New-Object System.Windows.Forms.Button 
$Okbutton1.Location = New-Object System.Drawing.Size(80,80)
$Okbutton1.Size = New-Object System.Drawing.Size(100,30)
$Okbutton1.Text = "OK1"
$Okbutton1.Add_Click({$Form.Close()
# do this with button
Write-Host "OK Button 1"}) 
$Form.Controls.Add($Okbutton1)

# Button 2
$Okbutton2 = New-Object System.Windows.Forms.Button 
$Okbutton2.Location = New-Object System.Drawing.Size(200,80)
$Okbutton2.Size = New-Object System.Drawing.Size(100,30)
$Okbutton2.Text = "OK2"
$Okbutton2.Add_Click({$Form.Close() 
# do this with button
Write-Host "OK Button 2"}) 
$Form.Controls.Add($Okbutton2)

# Show form
[void]$form.showdialog()

To stamp the registry in a Task Sequence, create two Run Commands in the Post Setup group (I add these as the final steps):

To set the field where Model is normally at

#1
cmd /c reg add “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\OEMInformation” /v Model /t REG_SZ /d “ABC WIN10 1.0” /f /reg:64

#2
cmd /c reg add “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\OEMInformation” /v BuildDate /t REG_SZ /d “%DATE% %TIME%” /f /reg:64

You may also use this to set Computer Description

cmd /c reg add “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters” /v svrcomment /t REG_SZ /d “ABC WIN10 1.0” /f 

To activate Office 2016 in a Task Sequence, create two Run Commands in the Post Setup group:

32 Bit

#1
cmd /c cscript.exe “C:\Program Files (x86)\Microsoft Office\Office16\ospp.vbs” /inpkey:SSSSS-DDDDD-WWWWW-TTTTT-GGGGG

#2
cmd /c cscript.exe “C:\Program Files (x86)\Microsoft Office\Office16\ospp.vbs” /act

64 Bit

#1
cmd /c cscript.exe “C:\Program Files\Microsoft Office\Office16\ospp.vbs” /inpkey:SSSSS-DDDDD-WWWWW-TTTTT-GGGGG

#2
cmd /c cscript.exe “C:\Program Files\Microsoft Office\Office16\ospp.vbs” /act

* Note, this is for Office 32 bit.

This is how you automate the process of naming computers during OSD.

PowerShell Method

First, create an application package, but choose Do not create a program, instead of Standard for the program type.

OSDComputerName.ps1

$SerialNumber = (Get-WmiObject -Class Win32_BIOS | Select-Object SerialNumber).SerialNumber
$OSDComputerName = "ABC-" + $SerialNumber
$TSEnv = New-Object -COMObject Microsoft.SMS.TSEnvironment
#$TSEnv.Value("$env:computername") = "$OSDComputerName"
$TSEnv.Value("OSDComputerName") = "$OSDComputerName"

#Rename-Computer -ComputerName "$env:computername" -NewName "$OSDComputerName"
#Rename-Computer -ComputerName "OSDComputerName" -NewName "$OSDComputerName"

Next, in the Task Sequence, create three Run Commands:

#1
powershell.exe -noprofile -command “Set-ExecutionPolicy Bypass LocalMachine” -force

#2
powershell.exe -noprofile -file OSDComputerName.ps1
* make sure you link an empty package (an application package with no program) to the OSDComputername.ps1

#3
powershell.exe -noprofile -command “Set-ExecutionPolicy RemoteSigned LocalMachine” -force

* Note, this method does require that PowerShell be enabled in the boot.wim

VBScript Method

Make an item in Post Setup pointing to this script. Add a SCCM Restart.

on error resume next

Dim computername

strComputer = "."

Set objWMIservice = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")

set colitems = objWMIservice.ExecQuery("Select * from Win32_BIOS",,48)

For each objitem in colitems
'Wscript.echo "Dell Service Tag: " & objitem.serialnumber
computername = objitem.serialnumber

Next

'returns machine model number only
'PRIMARY MODEL DETECTION
Set objWMI = GetObject("winmgmts:")
Set colSettings = objWMI.ExecQuery("Select * from Win32_ComputerSystem")

For Each objComputer in colSettings
LaptopModel = Trim(objComputer.Model)
Next

Select Case LaptopModel

Case "HP EliteBook 840 G3"
strModel = "8403"

Case "HP EliteBook 840 G2"
strModel = "8402"

Case "HP EliteBook 840 G1"
strModel = "8401"

Case "HP EliteBook Folio 9480m"
strModel = "9480"

Case "HP EliteBook Folio 9470m"
strModel = "9470"

Case "HP EliteBook Folio 9460m"
strModel = "9460"

Case "HP EliteBook 8470p"
strModel = "8470"

Case "HP EliteBook 8460p"
strModel = "8460"

Case "HP EliteBook 8450p"
strModel = "8450"

Case "HP EliteBook 8440p"
strModel = "8440"

Case "HP EliteBook 6930p"
strModel = "6930"

Case "HP EliteBook 2530p"
strModel = "2530"

Case "HP EliteBook 2540p"
strModel = "2540"

Case "HP Compaq dc7900 Small Form Factor"
strModel = "7900"

Case "HP Compaq 8000 Elite SFF PC"
strModel = "8000"

Case "HP Compaq 8200 Elite SFF PC"
strModel = "8200"

Case "OptiPlex 755"
strModel = "755"

Case "OptiPlex 745"
strModel = "745"

Case "Latitude D630"
strModel = "630"

Case "Latitude D620"
strModel = "620"

Case "Latitude D430"
strModel = "430"

End Select

'SECONDARY MODEL DETECTION
'used for models not explicitly defined
if strModel = "" then
'msgbox "no model was detected"
myLength = Len(LaptopModel)

For i = 1 To myLength
If Asc(Mid(LaptopModel, i, 1)) <> 32 Then
If Asc(Mid(LaptopModel, i, 1)) >= 48 And Asc(Mid(LaptopModel, i, 1)) <= 57 Then
myNumber = myNumber & Mid(LaptopModel, i, 1)
End If
Else
'msgbox("no numeric")
End If
Next
'msgbox(myNumber)
strModel = myNumber
end if

'testing only
'msgbox strModel

'renames machine with model number - service tag
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colComputers = objWMIService.ExecQuery ("Select * from Win32_ComputerSystem")

For Each objComputer in colComputers

err = objComputer.Rename(strModel & "-" & computername)

Next

WScript.Quit(0)

Notes

Command Line

netdom renamecomputer member /newname:member1.contoso.com /userd:administrator

PowerShell

Rename-Computer -ComputerName “$env:computername” -NewName “NewComputerName”

Rename-Computer -ComputerName “OSDComputerName” -NewName “NewComputerName”

Remotely Rename

$TargetComp=Read-Host -Prompt “Enter the Name of the Computer you want to change the name of “
$Credential=Get-Credential
$computerName = GWMI Win32_ComputerSystem -computername $TargetComp -Authentication 6
Write-host “Current Computer Name is ” $computerName
$name = Read-Host -Prompt “Please Enter the ComputerName you want to use.”
Write-host “New Computer Name ” $Name
$Go=Read-Host -prompt “Proceed with computer name change? (Y / N)”
If(($Go-eq”Y”)-or($Go-eq”y”))
{
$computername.Rename($name,$credential.GetNetworkCredential().Password,$credential.Username)
}
$Reboot=Read-host -Prompt “Do you want to restart the computer? (Y / N)”
If(($Reboot-eq”Y”)-or($Reboot-eq”y”))
{
restart-computer -computername $TargetComp
}

Screenshot

Single User

REG ADD “HKCU\Software\Citrix\Receiver” /f /v “HideAddAccountOnRestart” /t REG_DWORD /d “1”

 
For your image

1. Load the Default profile registry hive.

a. Open regedit.

b. Select HKEY_USERS, then click File > Load Hive

c. In the File name type: C:\Users\Default\ntuser.dat and click Open.

d. Type DefaultUser as the Key Name and click OK.

2. Navigate to HKEY_USERS > DefaultUser > Software > Citrix > Receiver

3. Create a new DWORD (32-bit) Value and name it HideAddAccountOnRestart.

4. Set the value data to 1.

5. Unload the Default User hive by selecting DefaultUser, the click File > Unload Hive.

Notes

REG ADD “HKLM\Software\Policies\Citrix” /f /v “EnableX1FTU” /t REG_DWORD /d “0”

https://support.citrix.com/article/CTX135438.?_ga=2.137409657.835403622.1516202909-1506665665.1515700878

Tested under Windows 7 & 10

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run” /v “SunJavaUpdateSched” /f /reg:64

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy” /v EnableAutoUpdateCheck /t REG_DWORD /d 0 /f /reg:64

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy” /v EnableJavaUpdate /t REG_DWORD /d 0 /f /reg:64

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy” /v NotifyDownload /t REG_DWORD /d 0 /f /reg:64

reg delete “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run” /v “SunJavaUpdateSched” /f /reg:32

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy” /v EnableAutoUpdateCheck /t REG_DWORD /d 0 /f /reg:32

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy” /v EnableJavaUpdate /t REG_DWORD /d 0 /f /reg:32

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy” /v NotifyDownload /t REG_DWORD /d 0 /f /reg:32