Category: General Tech

Joining two tables using SQL makes it possible to combine data from two (or more) tables based on a similar column between the tables. The JOIN clause will affiliate rows that have matching values in both tables from the column being joined on and render the results across rows in the result set.  There are […]

FOG is a fantastic tool and while we would really need two hours or more to show you how it can most benefit you in your environment, last week’s webcast is a good place to start and get your feet wet. In the webcast, Lex and Kris show you how to create and use Snapins […]

Intel recently fixed a vulnerability with the Intel Processor Identification Utility (advisory here).   You may not think this software is on your network, but are you certain? With PDQ Inventory you can be certain! Find all installs of Intel Processor Identification Utility with PDQ Inventory Let’s scan for all applications installed on all our […]

What is SQL? “SQL” stands for Structured Query Language and is used to manage, interact with, and retrieve data from a database. PDQ Inventory uses SQLite which is a lighter version of SQL’s syntax but still fully functional for extracting data. SQLite is file-based unlike other databases you may be more familiar with (Oracle, MySQL, […]

  Intel recently released a firmware advisory for their (Next Unit of Computing) NUC devices. These advisories come fairly frequently from the many different vendors and companies who have a large market share in the tech industry and is not meant to be alarming or scary. The advisory mentions the existence of a vulnerability in […]

Hello there! BlueKeep (CVE-2019-0708) is a dangerous vulnerability in Microsoft’s Remote Desktop Protocol (RDP). It is wormable (it can spread autonomously from computer to computer), so you should patch it ASAP. I wrote a PowerShell script to help you find the computers you need to patch. The PowerShell Script My script runs rdpscan, parses the […]

  PowerShell Have you ever wanted to gather data from a Confluence page automagically? In this post, I’ll show you how gathering Confluence page data with PowerShell can do just that. I use Confluence pages internally to track lists of items I’m working on and to view current progress. For instance, I have a goal […]

I recently figured out a way to automatically patch Slack in our environment AND apply a dark theme to any user who wants it. I accomplished this with PowerShell, this Github repository, and PDQ Deploy and PDQ Inventory. If dark mode allows you to see better, cranks your hacker image up to the next level, or […]

Have you always liked the idea of scripting and automating, or even dipped your toes in a bit, but felt overwhelmed and didn’t know where to start? I was there a few years ago when I was asked to switch to our Automation/QA team. Are you someone who’s taken the leap and uses PowerShell scripts […]