When you have a central file that controls workstation behavior (such as Oracle database locations), you want to automatically copy it down to the workstations each day, so you use a scheduled task. You use SCCM to deploy the task.
Reads the 32 and 64 bits DSN information from the registry and makes a spreadsheet of the results.
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 188.8.131.52 ' 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.