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, […]

PowerShell Classes Last week on PDQ Live, we went over PowerShell classes and when, why, and how to use them. Why use classes over functions? Class Basics Creating an example class object Where PowerShell classes fall short Creating a bar and adding drinks  Using the variable ‘$This’ Q&A Question 1 Q&A Question 2 Q&A Question […]

  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 […]

A Certifiably, Registered DNS Problem I have a problem. Not a drinking problem, not even a personal problem. A problem with how Windows handles DNS registration. When I move my laptop from my wired dock to our wireless connection, the DNS entry is, annoyingly, no longer correct. The DNS server still reports the old address. […]

This blog is a follow-up to a recent blog I published about importing Product Keys into PDQ Inventory with SQLite and PowerShell. (If you are looking for that blog – go here) Something I didn’t touch on in the other blog was concerning possible performance hurdles that you may run into when playing around with […]

Once upon a time, I was asked how to go about bulk importing product keys into PDQ Inventory during a webcast. Easy peasy, I thought, as I babbled on for a bit until I realized that I could write a blog instead. So voila! Blog! Preparation (and deep breaths) First and foremost, this functionality already […]

Last week on PDQ Live, we went through the SQL report builder in PDQ Inventory, with examples tricks and tips. SQL made Simple What is the difference between a basic and SQL report? What is a SQL report? SQL report basic syntax example. SQL report advanced syntax example. Computer ID as the primary key for […]

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 […]