SCCM - Dealing with updates that won't download
General Guidance on some ways to fix errors related to patches not downloading in SCCM Continue Reading...
SQL Code for SCCM Status Message Viewer
I found myself juggling many different Status Message views in SCCM to try to keep on top of various messages that would arise in one environment. So I did what anyone would do, and through liberal code-reuse and copy pasting, I reinvented the wheel, to get back that SMS 2003 Status Message viewer, which was missing from CM 2007 for some reason Continue Reading...
Hyper-V, fixing moved VHD files
Here is a scenario for you: some lowly admin thinks he will free up space by moving a VHD file, or perhaps you add more storage to your home test lab, and move your VHD files to the new drive. If you tried this operation while the VM is running, the file copy will fail. If you try this on saved or shut down VMs, you can definitely move the virtual hard drive (.vhdx file) which will cause the VM associated with it to rather predictably fail when powered on, as seen below. Continue Reading...
Resolving 'No Programs available from a Terminal Services Session'
Another SCCM post here. You've probably been in this scenario before: You have a user complaining that an advertisement doesn't work from his/her computer and they are being vague about it. Typically, we would dive in with SCCM Client Center or read the logs (or status messages from a program, more on that in a bit) to determine what went wrong. Continue Reading...
PowerShell - getting Remote network adapters
How to work with Remote Network Adapters in PowerShell! Continue Reading...
SCCM Resolving Error 620 'The Delete Statement Conflicted with the Reference Constraint…'
Ah yes, who doesn't love these pretty red icons. Like little Christmas ornaments. Anyway, if you're like me, you want an all-green and all-happy SCCM Summary page, and not just because you have a scheduled task or Status Filter to reset counts every thirty minutes. (If you're doing this, consider yourself admonished!). So, why does this happen and what does 'The DELETE statement conflicted with the REFERENCE constraint' mean? We're not DBAs you know! Continue Reading...
