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...
SCCM SQL Reporting code "Computers with one of many installed apps"
Today at a Client, the need arose to create a report which would list computers that have any of two applications installed. Â The principles used could easily be modified to fit a much larger list of applications, if the need arises. Continue Reading...
Using Powershell Internet Explorer Object automation to save work!
At one client, I had to use the Microsoft Baseline Security Analyzer to obtain a list of locally installed patches on all workstations. Â This application runs a check for installed patches on target workstations, and returns the output of a .CSV file (I'm leaving out some steps, but this is close enough.) Â However, this list leaves a lot to be desired, namely what the patches or KBs were meant to address, among other issues. Â As the clients wanted to review over and approve each update before proceeding with the project, I had to do something about this. Continue Reading...
Skirting around 'Deny Remote Desktop Access' GPO Settings
From time to time, I'll encounter this issue. Â You're troubleshooting an issue and need to Remotely log-on to a workstation. Â You've effectively got the keys to the kingdom, and yet a desktop workstation GPO prevents you from logging on remotely. Â Such a bummer! Fortunately, if we know how GPO works...we can hack our way around it! Continue Reading...
PowerShell Data deduplication commandlette Job types
In this post, we dive into some of the options for the dedupe cmdlets in PowerShell, so you can nuke your HomeLab too (foreshadowing...👻) Continue Reading...
PowerShell Nugget
PowerShell - How to retrieve Motherboard, Bios, Video Card, Ram info and more with just one command! Continue Reading...
