View gist:21c09fd1cce30f2a963af3ab84a8804c
# =============================================== | |
# Script to decline superseeded updates in WSUS. | |
# =============================================== | |
# It's recommended to run the script with the -SkipDecline switch to see how many superseded updates are in WSUS and to TAKE A BACKUP OF THE SUSDB before declining the updates. | |
# Parameters: | |
# $UpdateServer = Specify WSUS Server Name | |
# $UseSSL = Specify whether WSUS Server is configured to use SSL | |
# $Port = Specify WSUS Server Port | |
# $SkipDecline = Specify this to do a test run and get a summary of how many superseded updates we have |
View NewStart.xml
<LayoutModificationTemplate xmlns:defaultlayout="http://schemas.microsoft.com/Start/2014/FullDefaultLayout" xmlns:start="http://schemas.microsoft.com/Start/2014/StartLayout" xmlns:taskbar="http://schemas.microsoft.com/Start/2014/TaskbarLayout" Version="1" xmlns="http://schemas.microsoft.com/Start/2014/LayoutModification"> | |
<LayoutOptions StartTileGroupCellWidth="6" /> | |
<DefaultLayoutOverride> | |
<StartLayoutCollection> | |
<defaultlayout:StartLayout GroupCellWidth="6"> | |
<start:Group Name="Office"> | |
<start:DesktopApplicationTile Size="2x2" Column="0" Row="0" DesktopApplicationID="Microsoft.Office.EXCEL.EXE.15" /> | |
<start:DesktopApplicationTile Size="2x2" Column="2" Row="0" DesktopApplicationID="Microsoft.Office.ONENOTE.EXE.15" /> | |
<start:DesktopApplicationTile Size="2x2" Column="4" Row="0" DesktopApplicationID="Microsoft.Office.OUTLOOK.EXE.15" /> | |
<start:DesktopApplicationTile Size="2x2" Column="4" Row="2" DesktopApplicationID="Microsoft.Office.lync.exe.15" /> |
View PowerPrompt.ps1
##//Call this at the start of the TS. serviceui.exe -process:TsProgressUI.exe %windir%\System32\WindowsPowerShell\v1.0\powershell.exe -WindowStyle hidden -executionpolicy Bypass -file .\PowerCheck.ps1 | |
##//DEMO - https://imgur.com/a/44TfdxX | |
if (Get-WmiObject -Query "Select BatteryStatus from Win32_Battery WHERE BatteryStatus=2") {break} | |
else { | |
$T1 = New-Object -ComObject "Microsoft.SMS.TsProgressUI" | |
$T1.CloseProgressDialog() |
View gist:a79b8293dae43d8356206799ea453230
hide:windowsupdate;windowsinsider;gaming-gamebar;gaming-gamedvr;gaming-broadcasting;gaming-gamemode;gaming-trueplay;mobile-devices;gaming-xboxnetworking |
View unattended.xml
<?xml version="1.0" encoding="utf-8"?> | |
<unattend xmlns="urn:schemas-microsoft-com:unattend"> | |
<settings pass="oobeSystem"> | |
<component name="Microsoft-Windows-Shell-Setup" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> | |
<OOBE> | |
<ProtectYourPC>3</ProtectYourPC> | |
<HideWirelessSetupInOOBE>true</HideWirelessSetupInOOBE> | |
<HideEULAPage>true</HideEULAPage> | |
<HideLocalAccountScreen>true</HideLocalAccountScreen> | |
<HideOnlineAccountScreens>true</HideOnlineAccountScreens> |
View gist:5a942e87801a81b209df0ca54c95c3bd
Unlock | |
$SecureString = ConvertTo-SecureString "xxxxxx" -AsPlainText -Force | |
Unlock-BitLocker -MountPoint "D:" -Password $SecureString | |
EncryptD | |
.\manage-bde.exe -protectors -enable d: | |
$secure = ConvertTo-SecureString "xxxxxx" -AsPlainText -Force |
View getTPMVersionStatus.sql
SELECT distinct CS.Manufacturer0 as 'Manufacturer', | |
CS.Model0 AS 'Model', CS.Name0 as 'Name', TPM.SpecVersion0 as 'SpecVersion', | |
TPM.IsActivated_InitialValue0 as 'IsActivated_InitialValue', | |
TPM.IsEnabled_InitialValue0 as 'IsEnabled_InitialValue', | |
TPM.IsOwned_InitialValue0 as 'IsOwned_InitialValue', | |
TPM.ResourceID, | |
OPSYS.Caption0 as 'OS', | |
OPSYS.CSDVersion0 as 'ServicePack', | |
GSBIOS.SMBIOSBIOSVersion0 as 'BIOS', | |
GSBIOS.SerialNumber0 as 'Serial No.' |
View CheckWSUSAppPool
<# | |
.SYNOPSIS | |
Checks WSUS App Pool | |
.DESCRIPTION | |
Script will check status of WSUS APP Pool and if 'stopped' will email. Setup script as scheduled task on WSUS instance. | |
.NOTES | |
Version: 1.0 | |
Author: dpadgett | |
Creation Date: 07/02/17 | |
Purpose/Change: Production |
View Office Channel.sql
SELECT sys.Name0 [Computer Name] , | |
"Update Channel" = | |
CASE | |
When O365.CDNBaseUrl00 = 'http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114' Then 'Semi-Annual Channel' | |
When O365.CDNBaseUrl00 = 'http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60' Then 'Monthly Channel' | |
When O365.CDNBaseUrl00 = 'http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf' Then 'Semi-Annual Channel (Targeted)' | |
When O365.CDNBaseUrl00 = 'http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be' Then 'Monthly Channel (Targeted)' | |
End | |
, |
View Customise-Win10.ps1
<# | |
.SYNOPSIS | |
Sets W10 1709 Options | |
.DESCRIPTION | |
Sets W10 1709 Options | |
.PARAMETER <Parameter_Name> | |
None | |
.INPUTS | |
None |
NewerOlder