Christopher Kibble's Technical Ramblings
open-menu closeme
  • SCCM SQL Query to Find Machines Impacted by AMT Firmware Exploit (INTEL-SA-00075)

    calendar 2017-05-02 · 2 min read · SQL ConfigMgr  ·
    Share on: twitter facebook linkedin copy

    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

    calendar 2016-05-27 · 2 min read · ConfigMgr SQL  ·
    Share on: twitter facebook linkedin copy

    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

    calendar 2015-10-27 · 2 min read · ConfigMgr  ·
    Share on: twitter facebook linkedin copy

    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

    calendar 2015-06-08 · 3 min read · ConfigMgr SQL  ·
    Share on: twitter facebook linkedin copy

    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

    calendar 2015-06-03 · 2 min read · ConfigMgr Excel  ·
    Share on: twitter facebook linkedin copy

    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

    calendar 2015-05-12 · 3 min read · ConfigMgr  ·
    Share on: twitter facebook linkedin copy

    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

    calendar 2014-08-13 · 2 min read · ConfigMgr SCCM  ·
    Share on: twitter facebook linkedin copy

    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
  • SCCM Query to Get Screen Resolutions

    calendar 2014-08-04 · 2 min read · ConfigMgr SQL  ·
    Share on: twitter facebook linkedin copy

    I wrote the following queries to find the video resolutions used by clients reporting into SCCM. They currently only look at Windows Workstations 6.x (excludes servers, and also anything older than Windows Vista or whatever v7 ends up being), and only those who have submitted a hardware inventory in the last 30 days. …


    Read More
  • Deleting Inactive AD Computers from SCCM 2012

    calendar 2014-07-28 · 2 min read · ConfigMgr PowerShell  ·
    Share on: twitter facebook linkedin copy

    I wrote the following script to find inactive computers in Active Directory and then find & delete them from SCCM. Feel free to use & abuse as you see fit, but always run through a test environment first. My version makes sure to target only Windows Operating Systems, and excludes anything with Server in the caption - …


    Read More
  • Creating an SMS 2003 CCR within Excel

    calendar 2009-07-07 · 3 min read · ConfigMGr Excel  ·
    Share on: twitter facebook linkedin copy

    This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I created the following function to create Microsoft SMS 2003 Client Configuration Requests from within Excel and dump them all out into a temporary directory for me …


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

Chris Kibble

Technologist, perpetual student, teacher, continual incremental improvement.
Read More

Recent Posts

  • Setting up a WebDAV Server on IGEL OS
  • Set up IGEL with Zscaler Root Certificate Authority
  • IGEL First Time Setup
  • Finding or Recovering your WSL Data
  • Lenovo Vantage IMController Vulnerability - ConfigMgr Query
  • Lenovo Thunderbolt Firmware Version Detection
  • Import Teams Meeting Into Camtasia
  • WizTree Scan Remote System

Categories

CONFIGURATION MANAGER 20 SYSTEMS ADMINISTRATION 13 TROUBLESHOOTING 11 PKI 10 POWERSHELL 9 CONFERENCES 5 APPLICATION PACKAGING 4 IGEL 3 MSOFFICE 3 ACTIVE DIRECTORY 2 DOMAINS AND HOSTING 2 MCAFEE ENDPOINT ENCRYPTION 2 YNAB 2 EXCEL 1
All Categories
ACTIVE DIRECTORY2 APPLICATION PACKAGING4 CONFERENCES5 CONFIGURATION MANAGER20 DOMAINS AND HOSTING2 EXCEL1 GEEKING OUT1 GOOGLE1 GOOGLE CHROME1 IGEL3 IPHONE1 JAVA1 MCAFEE ENDPOINT ENCRYPTION2 MICROSOFT DOCS1 MSDOCS1 MSOFFICE3 NINITE1 PKI10 POWERPOINT1 POWERSHELL9 SYSTEMS ADMINISTRATION13 TROUBLESHOOTING11 WINDOWS 101 YNAB2
[A~Z][0~9]

Series

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

Tags

CONFIGMGR 20 POWERSHELL 17 MSOFFICE 12 CA 9 PKI 9 SQL 9 EXCEL 7 MMS 7 GOOGLE 4 AUTOIT 3 CHROME 3 IGEL 3 WINDOWS 10 3 DOMAINS 2
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA9 CAMTASIA1 CHROME3 CITRIX1 CONFIGMGR20 DOMAINS2 EDGE1 EXCEL7 FIRMWARE2 FLASH1 GITHUB2 GOOGLE4 IGEL3 IMH1 INDEX1 IPHONE2 JAVA1 LENOVO2 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE12 NAS1 NESSUS1 NINITE1 NOTEPAD++1 PKI9 POWERPOINT1 POWERSHELL17 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS 103 WIZTREE1 WSL1 YNAB2 ZSCALER1
[A~Z][0~9]
Chris Kibble

Copyright 2006-  CHRIS KIBBLE. All Rights Reserved

to-top