I wrote the following function to rerun an advertisement on a remote client computer using either the AdvertisementID or the PackageID. Like all sample code found online, please run through a test environment first, and use at your own risk!
I recently had to throw together a quick script to modify the registry of each current user on a set of given laptops, as well as any future users. While a GPO is normally the way to go for something like this, it wasn’t an option for me here. This builds a little more on my May 2017 post where I just needed to get the
Feel free to steal, use, and abuse – but like all samples found online, please run through a test environment first, and use at your own risk!
I created the follow SQL query to create a batch file that uninstalls all known versions of a piece of software. Feel free to use and tweak as you see fit. You should build the query first to make sure you’re only identifying the GUIDs for software you really want to uninstall. You’ll need to setup SSMS to output as text instead of grid view, then copy and paste into a new batch file and trim the top and bottom a bit to remove the junk that comes with the output.
The following SQL should help identify the state of impacted systems. Please review thoroughly before relying on this information, while I believe the results should be accurate, you should do your own due diligence. Please let me know if you find any errors or have any suggestions to return better data.
More information on INTEL-SA-00075 here.