Skip to content

Instantly share code, notes, and snippets.

site:microsoft.com -site:answers.microsoft.com -site:social.technet.microsoft.com -site:social.microsoft.com -site:social.msdn.microsoft.com wdfilter

@timbodv
timbodv / Office - execute update process.ps1
Last active December 19, 2019 22:38
Office - execute update process.ps1
# NOTE : doesn't appear to work for ConfigMgr managed clients; may be a further command line parameter I need to discover
# update Office silently
Start-Process -FilePath 'C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe' -ArgumentList '/update user updatepromptuser=false forceappshutdown=false displaylevel=false'
# update Office with feedback
Start-Process -FilePath 'C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe' -ArgumentList '/update user updatepromptuser=true forceappshutdown=false displaylevel=true'
# disable the CAPS LOCK key in Windows, a reboot is required to take effect
if (-not $(Test-Path "HKLM:\SYSTEM\CurrentControlSet\Control\Keyboard Layout")) {
New-Item -Path "HKLM:\SYSTEM\CurrentControlSet\Control" -Name "Keyboard Layout" -ItemType Key
}
Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Control\Keyboard Layout" -Name "Scancode Map" -Value 0,0,0,0,0,0,0,0,2,0,0,0,0,0,58,0,0,0,0,0 -Type Binary
Select * from SMS_R_SYSTEM where SMS_R_SYSTEM.ResourceId in (SELECT ResourceId FROM SMS_CM_RES_COLL_xxxxxxx)
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client
from SMS_R_System
where SMS_R_System.ResourceId in (select ResourceID from SMS_CM_RES_COLL_CollectionId) and SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_CollectionId)
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client
from SMS_R_System where SMS_R_System.SystemGroupName = "DOMAIN\\GroupName"
@timbodv
timbodv / SccmTriggerClientAction.ps1
Created February 20, 2017 11:22
Trigger an SCCM/CCM client action
# list of all client action trigger codes
# https://blogs.technet.microsoft.com/charlesa_us/2015/03/07/triggering-configmgr-client-actions-with-wmic-without-pesky-right-click-tools/
$assets = 'PC1', 'PC2', 'PC3', 'PC4', 'PC5'
foreach ($asset in $assets) {
$smsclient = [wmiclass] "\\$asset\root\ccm:sms_client"
$smsclient.TriggerSchedule('{00000000-0000-0000-0000-000000000021}')
}
# KB3125574 Convenience rollup update for Windows 7 SP1 and Windows Server 2008 R2 SP1 (https://support.microsoft.com/en-us/kb/3125574)
$pathToInstallWim = 'c:\temp\install.wim'
$pathToMountFolder = 'c:\temp\mount'
$pathToPatches = 'c:\temp\patches'
$patches = 'Windows6.1-KB3020369-x64', # servicing update
'windows6.1-kb3125574-v4-x64', # convenience update
'Windows6.1-KB3138612-x64.msu', # help Windows Update work faster
'Windows6.1-KB3145739-x64.msu', # help Windows Update work faster
# first cut of a logstash import for Config Mgr / SCCM 2012 logfiles
input {
file {
path => "c:\temp\logs\CcmExec.log"
start_position => beginning
codec => multiline {
# match any line not starting with <
pattern => "^(?:<).*"
what => "previous"
negate => true
<?xml version="1.0" encoding="UTF-8"?>
<SequencerTemplate xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<AllowMU>false</AllowMU>
<AppendPackageVersionToFilename>false</AppendPackageVersionToFilename>
<AllowLocalInteractionToCom>false</AllowLocalInteractionToCom>
<AllowLocalInteractionToObject>false</AllowLocalInteractionToObject>
<FullVFSWriteMode>false</FullVFSWriteMode>
<ExcludePreExistingSxSAndVC>false</ExcludePreExistingSxSAndVC>
<FileExclusions>
<string>[{Profile}]\NTUSER.DAT</string>