This shows how a compliance setting can use a service account to copy from the network to a local drive
This will decode an ORA file and send it out in CSV format. Not completed, but it works sending it to the screen #include Global $sFileRead Read_TNS_File("TNSNAMES.ORA") Func Read_TNS_File($ThisFilename) Local $hFileOpen = FileOpen($ThisFilename, $FO_READ) If $hFileOpen = -1 Then MsgBox($MB_SYSTEMMODAL, "", "An error occurred when reading the file.") Return False EndIf Local $sFileRead = FileRead($hFileOpen) $sFileRead … Continue reading Decode an ORA file
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 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