SCCM Resolving Error 620 'The Delete Statement Conflicted with the Reference Constraint…'

August 27, 2013 FoxDeploy

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"

August 26, 2013 FoxDeploy

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!

August 23, 2013 FoxDeploy

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

August 23, 2013 FoxDeploy

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

August 23, 2013 FoxDeploy

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

August 22, 2013 FoxDeploy

PowerShell - How to retrieve Motherboard, Bios, Video Card, Ram info and more with just one command! Continue Reading...

Microsoft MVP

Five time Microsoft MVP, and now I work for the mothership

Need Help?

Get help much faster on our new dedicated Subreddit!

depicts a crowd of people in a night club with colored lights and says 'join the foxdeploy subrreddit today'

Blog Series
series_sml_PowerShellGUI series_sml_IntroToRaspberryPi Programming series_sml_IntroToWindows Remote Management Series The Logo for System Center Configuration Manager is displayed here Depicts a road sign saying 'Learning PowerShell Autocomplete'

Blog Stats