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 …
Read MoreThe following snippet of PowerShell will collect the list of profiles active on a system from the registry and populate an array. I remove any profile folder that does not exist, as well as any that are within the Windows folder (e.g. NetworkService, LocalSystem), but you can modify as you see fit if that doesn't meet …
Read MoreThe 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 …
Read MoreChrome does not remove "Recent Printers" from the print option box when a user or an administrator deletes a printer from the machine. This can cause problems when a printer is removed by policy or is updated with a new print server name, but a user continues totry and print to the old server. This script will remove …
Read MoreThe following query will allow you to search the view v_R_user in the Microsoft Configuration Manager database so that you can identify a manager and then find everyone who works for that manager all the way down the tree. I've found this useful in the past for joining with other information in the database to identify …
Read MoreIn this video demo I'm going to show you how use VLOOKUP on a table in Excel. In order to see the text clearly, please set the video to one of the two HD options using the gear icon. Attachment: Using the VLOOKUP Function
Read MoreI recently was troubleshooting the following error on roughly 400 systems that we were deploying the Citrix Receiver v14 to: CustomAction +DVCRenderingAdapter.dll.827545C6_7013_4DE1_8E6C_DAEE4C57F54A returned actual error code -2147319780 (note this may not be 100% accurate if translation happened inside sandbox)MSI …
Read MoreI wrote the following script to quickly output how much disk space my SCCM Distribution Points consumed. If you're not running a CAS, you'll want to change line 21 to point to your primary. This requires that you have the Configuration Manager console installed on the machine. It's not pretty but it did the trick. I'm …
Read MoreIn this video demo I'm going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you're looking for. At the end of the demo, we'll touch on the IF function and show you how you can manipulate the table based on some set …
Read MoreI was fortunate enough this year to be able to take a considerable amount of time off and explore some absolutely stunning regions in Europe. This wasn't one of those "disconnect from the world" trips, however. While I did remove my office mail profile, Microsoft Lync, and my work OneDrive from my phone, I still stayed …
Read More