A few months back, I had built what I dubbed the “Ultimate Oracle Client Deinstaller.” It could handle the deinstallation of Oracle database clients 11g, 12c, and 19c to include having multiple clients installed- even if they share the same Oracle_Home location. Recently, I ran into some alternate configurations of the Oracle client that required…
Author: paytonflint
PowerShell – Add + Trust PsGallery & NuGet
If you do a lot of PowerShell work, you may find yourself frequently using NuGet or PsGallery. I’ve put a couple functions together that quickly add the PsGallery repository and NuGet respectively, and add trust to these sources. These functions were built to be modular so they could be modified for other sources as well….
PowerShell – Add Hosts to AD Group
Here’s another simple script I put together. It allows you to specify a Security Group in Active Directory, and add a list of hosts to this group. Simple, but yet another tool that every SysAdmin should have in their repository.
PowerShell – Get OS By Device Name
Here’s a basic script I put together to generate a .CSV report of the operating system for a given list of device names. A handy tool for any sysadmin to add to their repository.
PowerShell – Get Affiliated Devices by User
The Configuration Manager PowerShell module contains the Get-CMUserDeviceAffinity cmdlet to allow one to use an AD user object to search for devices that the user is the Primary User for. I’ve written a script which first runs an LDAP query to derive the AD user objects from a list in First Name + Last Name…
Homelab – Hardware Hacking – Add Custom Pi Pico Controls to USB Switch
A USB switch is a convenient piece of hardware to have in your homelab if you’d like to interact with multiple boxes from your same mouse and keyboard. I have one that from the factory, allowed one to cycle through a selection to choose a device, but you could not select and go directly to…
PowerShell – CM Uninstall Collections + Deployments Tool
To maintain a healthy environment, providing capability for other supporting teams to remove applications using CM may be desirable. One way this might be arranged is to provide the ability to place devices in predetermined uninstall collections that already have required uninstall deployments for their corresponding application. In this scenario, it would be desirable for…
PowerShell – Save Updates And Import to WSUS
Since Internet Explorer has now been deprecated, there is a need to import updates to WSUS natively without the installation of additional browsers. I’ve found that some of the functionality can be accomplished with Microsoft MVP Chrissy Lemaire’s “KBUpdate” PowerShell module, but it merely facilitated the process by downloading the update, and thus, I did…
PowerShell – Add/Modify Registry Key
Creating or modifying registry keys in PowerShell is a task that comes up frequently when working with Windows. I’ve put together a function that will check for and create a registry key if it does not exist. Just specify the key path, name, and value. As you can see in the first execution, the script…
PowerShell – Report CM Application Information
A common problem with applications in Configuration Manager is that an uninstall command has not been specified for many applications. This tends to cause the accumulation of technical debt. As applications age, it will eventually become desirable to remove them from the environment en masse. The ideal time to specify an uninstall command is when…