Christopher Kibble's Technical Ramblings
  • How to Query the SCCM Database With SQL Server Mgmt Studio

    2020-12-26 ConfigMgr SQL

    I'm going to show you how to use SQL Server Management Studio to get data from Configuration Manager. I want to thank Adam Cook and Adam Gross who both gave me the encouragement to finally put this together. For best SQL readability, make sure you're watching in HD.

    Read More
  • Error "The specified server cannot perform the requested operation" when using Export-CMApplication

    2020-09-08 ConfigMgr

    Quick post today because I couldn't find this error anywhere online. I'm running Configuration Manager 2002 and was exporting an application and was getting this error thrown in Powershell: Export-CMApplication : The specified server cannot perform the requested operation. After some digging around, I realized it was …

    Read More
  • Getting the Email Address of all Configuration Manager Users

    2019-02-20 ConfigMgr SQL

    The following short and sweet snippet of PowerShell will extract the list of admins from your SCCM environment and then get their email addresses. At the end, you can dump $email into a text file, or perhaps set it to your clipboard to paste into Outlook. 1# Script assumes you have CM Module Loaded 2# Script assumes …

    Read More
  • Inventory of Missing and Disabled Configuration Manager Users

    2019-02-18 ConfigMgr

    I wrote the following script to inventory the administrative users of my Configuration Manager (SCCM) environment as they relate to Active Directory. The end result is a list of users who no longer exist in Active Directory, users who are in Active Directory but disabled, and users who are granted rights in multiple …

    Read More
  • Making a ConfigMgr Task Sequence Available to a User Collection

    2018-08-21 ConfigMgr

    A recently had a requirement to bundle a number of applications together into a few different task sequences to make available to a user collection. After a bit of research, I discovered that this is a pretty common question, and that there is no built-in method to make this available. Below, I'll walk through how I …

    Read More
  • SCCM Console Setup Terminates with Exit Code 6

    2018-07-11 ConfigMgr

    If you're trying to automate the deployment of the SCCM Console through Configuration Manager, you may find that running it quietly throws something like this in AppEnforce.log: Process 9976 terminated with exitcode: 6 For some reason, Microsoft has decided not to define a default installation path when running the …

    Read More
  • Three ways to find the right view in your SCCM Database

    2018-06-01 ConfigMgr SQL

    When it comes to data in SCCM, there is no shortage of what you can get access to, but where exactly do you find it? Below I'll outline three methods I've used in the past. First, the TechNet documentation. I'm going to be honest, I haven't actually looked here in quite some time. It's available, but since I've been …

    Read More
  • Using PowerShell to Rerun an SCCM Client Advertisement

    2017-09-30 ConfigMgr PowerShell

    I wrote the following function to rerun an advertisement on a remote client computer using either the AdvertisementID or the PackageID. Like all sample code found online, please run through a test environment first, and use at your own risk! 1<# …

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

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Setup Google Cloud Certificate Authority - Part 2
  • Standing Up a Microsoft Certificate Authority - Part 8
  • Setup Google Cloud Certificate Authority - Part 1
  • Standing Up a Microsoft Certificate Authority - Part 7

Categories

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

Series

STANDING-UP-A-CERTIFICATE-AUTHORITY 8 VIDEOS 4 STANDING-UP-A-GOOGLE-CERTIFICATE-AUTHORITY 2

Tags

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