Category: SQLite

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

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

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

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

SQL Snippets Episode 2 In episode 1, we explained how SQL reports can be utilized in PDQ Inventory and PDQ Deploy. Today, we’ll discuss customizing SQL reports and how they can optimize your report results by using the ‘WHERE’ clause. Recap of Episode 1: A reports folder was created and a SQL report was built and […]

Welcome to SQL Snippets! Writing SQL queries and building SQL reports on any platform may not always be a simple task. The SQL Snippets series is designed to help teach, assist, and bridge some gaps of knowing what you want in a SQL report and getting the desired results. We’ll be demonstrating examples using both […]