Author: Stephanie

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

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

Is your PDQ Deploy console starting to get unorganized and messy but you’re unsure where to begin cleaning it up? Are you afraid of clearing out old/unused deployments in fear of removing something relevant and making a permanent mistake? Are you even more fearful of SQL/SQLite code? Using SQLite queries can be a quick path […]