Schedule a task to update TNS files

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. 

Advertisements

Add and Remove from collection using Excel VBA

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 1.1.0.0 ' 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