Find advertisements (packages) where a system reported a status in the last N days. For example, what advertisements were applied last night? Or in the last week? Includes old advertisements that were recently applied, so it helps with cleanup of old packages.
This is crude and unfinished but I wanted to post it ASAP so I don't lose it. [Excel VBA code] Option Explicit Sub ConnectWMIServer() ' version 22.214.171.124 ' Author Roger 7/19/2017 Const wbemFlagReturnImmediately = &H10 Const wbemFlagForwardOnly = &H20 Dim objWMIService, StrQuery, ColItems, objItem Dim objSmsNewRule, objSMS_Collection Dim ComputerName: ComputerName = "XX6761" Dim CollectionID: … Continue reading Add and Remove from collection using Excel VBA
Capture the fleeting .PS1 file while it is briefly in the SystemTemp folder
A nice SQL query for showing what Software Updates are pending.
Visit the Microsoft Download Center to install the System Center Configuration Manager Cmdlet Library.
This shows how to remotely trigger SCCM compliance settings.
This is for a particular app that had some update requirements. @Echo on REM Uninstall ININ / ICIC elements, apply MS patches, Install latest ININ / ICIC elements REM 26-Jun-2017 REM Roger C. Set MyVer=126.96.36.199 Set MyError=NO Set MyWarning=NO set DEBUGGING=NO Call :InitLog if "%DEBUGGING%"=="YES" @echo on REM ============================================================== REM Set some required variables based … Continue reading Remove app, install MS Updates, install app