Christopher Kibble's Technical Ramblings
open-menu closeme
  • Collecting Tenable Nessus Agent Status With Powershell

    calendar 2021-08-25 · 5 min read · Nessus PowerShell  ·
    Share on: twitter facebook linkedin copy

    Information from the Tenable Nessus Agent, as far as I'm aware, is only available when using the Nessus Client command line application (NessusCli.exe). In this post, I'm going to show how we can capture this with PowerShell. I'm going to walk through how I do this step-by-step. If you're looking for just the script, …


    Read More
  • Excel COM Error Cant Load Library Fix

    calendar 2021-02-08 · 1 min read · Excel PowerShell MSOFFICE  ·
    Share on: twitter facebook linkedin copy

    I've been getting the following error when trying to access a new Excel COM object: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the …


    Read More
  • Script to Find Attached USB Mass Storage Devices

    calendar 2020-08-20 · 2 min read · PowerShell  ·
    Share on: twitter facebook linkedin copy

    I wrote the following script to find and list attached USB Mass Storage Devices and determine the disks and partitions associated with them. 1$usbKeysAttached = Get-PnpDevice -Class USB -Status OK -FriendlyName "USB Mass Storage Device" 2 3$aAttachedDisks = @() 4 5ForEach($key in $usbKeysAttached) { 6 $pnpProperties = …


    Read More
  • Better PoSH: Using $PSDefaultParameterValues

    calendar 2019-07-15 · 2 min read · PowerShell  ·
    Share on: twitter facebook linkedin copy

    Today's quick PoSH tip comes from a conversation I had with Kevin Crouch (@PsychoData) and Brett Miller (@BrettMiller_IT), and I got to learn about the $PSDefaultParameterValues variable, which I'd never used before. Essentially, $PSDefaultParameterValue allows you to define ahead of your functions how certain …


    Read More
  • Detecting Skype Activity with PowerShell

    calendar 2019-07-11 · 2 min read · PowerShell Skype  ·
    Share on: twitter facebook linkedin copy

    I'm working on a project to get a number of drivers updated across an environment. One of the biggest problems is that if we update certain audio, video, or network drivers while the user is in a Skype call, the call will fail. Often in testing I found that reconnecting to the Skype call or presentation was difficult …


    Read More
  • Better PoSH: Avoid Using += for Arrays

    calendar 2019-07-08 · 2 min read · PowerShell  ·
    Share on: twitter facebook linkedin copy

    I've found myself hanging around some PowerShell chats lately, and I've been picking up on a lot of neat tricks to write better code. This one comes my way via Adam Cook from his blog post on his awesome new function Get-CMUnusedSources (seriously, if you're a ConfigMgr shop, check it out). Since PowerShell is one of …


    Read More
  • Calling sendmail from PowerShell on Linux

    calendar 2019-04-03 · 3 min read · PowerShell  ·
    Share on: twitter facebook linkedin copy

    I haven't blogged about it a lot, but I am trying to learn what I can about PowerShell on Linux. I feel like more and more services are headed to the cloud, and (even in Azure) will be able to run on Linux devices. Being able to write portable scripts to move between what I manage today, and what I may be asked to …


    Read More
  • PowerShell Script to Query YNAB API

    calendar 2019-02-11 · 1 min read · PowerShell YNAB  ·
    Share on: twitter facebook linkedin copy

    In a post last week, I talked about how I've begun using YNAB in 2019 to manage my finances. As soon as I learned there was an API, you know I had to dig in and see what it could do. Below I've posted a short PowerShell script to query all credit cards and lines of credit and then dump them out to the console. Nothing …


    Read More
  • Convert Office 365 Version Numbers to Build Numbers for SCCM Reporting

    calendar 2018-07-24 · 1 min read · SQL MSOffice PowerShell  ·
    Share on: twitter facebook linkedin copy

    I've written the following three PowerShell functions to build a mapping of Office 365 ProPlus version numbers (e.g. 16.0.10205.2009) to more reportable build numbers (e.g. 1806). I've created the following three functions to start: Get-Office365BuildToVersionMap Get-OfficeBuildListToCase Get-OfficeBuildListToSQLTable …


    Read More
  • Stop Using the Pipeline in PowerShell

    calendar 2018-05-22 · 2 min read · PowerShell  ·
    Share on: twitter facebook linkedin copy

    Last week I Fred Bainbridge and Ryan Ephgrave's MMSMOA session where they showed us that we shouldn't be using the pipeline anymore. Before beginning the session, I was as confused as you might be about why. The guys did a great job explaining it and I'm going to show you why in the same manner they showed me. Let's …


    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