Christopher Kibble's Technical Ramblings
  • SCCM SQL Query to Build Uninstaller Batch File

    2017-05-26 ConfigMgr SQL

    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 More
  • SCCM SQL Query to Find Machines Impacted by AMT Firmware Exploit (INTEL-SA-00075)

    2017-05-02 SQL ConfigMgr

    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 …

    Read More
  • Recursively Query User View in Configuration Manager

    2016-05-27 ConfigMgr SQL

    The 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 More
  • PowerShell Script to Report SCCM DP Disk Space

    2015-10-27 ConfigMgr

    I 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 More
  • SCCM SQL Query to Determine Installed Browsers

    2015-06-08 ConfigMgr SQL

    I recently wrote the following SQL Query to help identify which browsers are installed across our environment. A straight Add/Remove Programs (v_AddRemovePrograms) query didn't really return the data in such a way that made it easy to determine major version of Firefox or Chrome, and doesn't include Internet Explorer …

    Read More
  • Creating an SCCM Collection from an List of Computers in Excel

    2015-06-03 ConfigMgr Excel

    I frequently use this trick to manage collections of computers in SCCM where the original list comes from Excel, or from a query of another system that I can dump into Excel. Doing it this way, you don't have to rely on adding computers one at a time to a collection query or dumping systems into tools like the the …

    Read More
  • SCCM 2012 DP Errors: SendFiles Failed

    2015-05-12 ConfigMgr

    One of my distribution points recently stopped getting DP updates. I tried my normal troubleshooting steps - creating a new package, checking disk space, source folder permissions, server reboot, etc., but no dice. I reviewed the DISTMGR.LOG on the primary site responsible for the distribution point, and found the …

    Read More
  • Setup was unable to compile Sql CE script file CIStateDBUpgrade.sqlce during CCM Setup

    2014-08-13 ConfigMgr SCCM

    Recently I was troubleshooting a Windows 7 Service Pack 1 system where the CCM Client would not install manually or via push. The following was reported in the CCMSETUP.LOG: MSI: Setup was unable to compile Sql CE script file C:\Windows\CCM\CIStateDBUpgrade.sqlce. The error code is 87D00244. MSI: Action 13:27:05: …

    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Excel COM Error Cant Load Library Fix
  • Running Powerpoint in Windowed Mode
  • Managing Chrome in the Enterprise
  • Setup Google Cloud Certificate Authority - Part 2

Categories

CONFIGURATION-MANAGER 19 PKI 9 POWERSHELL 9 SYSTEMS-ADMINISTRATION 9 TROUBLESHOOTING 9 CONFERENCES 5 APPLICATION-PACKAGING 4 MSOFFICE 3 ACTIVE-DIRECTORY 2 DOMAINS-AND-HOSTING 2
All Categories
ACTIVE-DIRECTORY2 APPLICATION-PACKAGING4 CONFERENCES5 CONFIGURATION-MANAGER19 DOMAINS-AND-HOSTING2 EXCEL1 GEEKING-OUT1 GOOGLE1 GOOGLE-CHROME1 IPHONE1 JAVA1 MCAFEE-ENDPOINT-ENCRYPTION2 MICROSOFT-DOCS1 MSDOCS1 MSOFFICE3 NINITE1 PKI9 POWERPOINT1 POWERSHELL9 SYSTEMS-ADMINISTRATION9 TROUBLESHOOTING9 WINDOWS-101 YNAB2
[A~Z][0~9]

Series

STANDING-UP-A-CERTIFICATE-AUTHORITY 8 VIDEOS 5 STANDING-UP-A-GOOGLE-CERTIFICATE-AUTHORITY 2 SPEAKING-ENGAGEMENTS 1

Tags

CONFIGMGR 19 POWERSHELL 16 MSOFFICE 11 SQL 9 CA 8 PKI 8 EXCEL 7 MMS 7 GOOGLE 4 AUTOIT 3
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA8 CHROME3 CITRIX1 CONFIGMGR19 DOMAINS2 EDGE1 EXCEL7 FLASH1 GITHUB2 GOOGLE4 IPHONE2 JAVA1 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE11 NAS1 NINITE1 NOTEPAD++1 PKI8 POWERPOINT1 POWERSHELL16 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS-103 YNAB2
[A~Z][0~9]