Category: SQLite

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

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