Category: PDQ Inventory

Summer is winding down and school is back in session for many people across the country. So, if you were busy fitting in a last-minute vacation, taking kids school shopping, or gearing back up for the next quarter and missed out on the webcast last week, no need to fret. We’ve got you covered so […]

Last week on PDQ Live! we went through some of the inner workings of PDQ Deploy and PDQ Inventory. If you missed it that’s ok, get ready to lift the hood and let’s get this webcast recap started.  How do PDQ Inventory heartbeats work? How is the online/offline status determined? (1:10) How to connect to […]

Episode 1 left off using a simple SQL query SELECTing four columns FROM the Computers table in PDQ Inventory: SELECT ComputerId, Name, OSName, IsOnline FROM Computers When writing SQL queries there will be times, for any reason, you’d rather call a column by a different name. You can easily rename a column (or table, introduced […]

  Writing SQLite reports using SELECT FROM Writing SQLite reports properly requires a specific format and order of operations in which the clauses/commands are used.  All SQL reports, in standard order, start with the ‘SELECT’ clause and get more in-depth from there. The SELECT clause is used to select/choose data from a table and/or database. […]

If you’re still manually drafting reports you’ll want to review our webcast from last week. Why not streamline those tedious tasks and schedule the reports you have to do on a regular basis using Auto Reports in PDQ Inventory. Our goal at PDQ.com is to take work off your plate so you have time for […]

PDQ Live If you missed out on our webcast last week, never fear, our webcast recap is here. Last week was our PDQ & A…your opportunity to ask questions, and we answer them. Watch the webcast here or keep reading if that’s more your thing. I am new to PDQ and love it so far. […]

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

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