SQL Report Design

Enter the SQL you wish to use for your report.

SQL Dialect

PDQ Inventory uses SQLite for its database.  You can familiarize your self with SQL As Understood by SQLite.

Table and Column Names

You can see a list of all table and column names on the left.  Simply double-click one of them to have them inserted into the SQL.

<ComputerFilter>

This special identifier within the SQL indicates where the filter clause for the computer collection source will go. If a report includes the Computers table it's a good idea to include this identifier so that the report can be run against a Collection. Without it, the report will always be run against all computers in the database. Do not include <ComputerFilter> if the Computers table isn't included, it will result in an error when the report is run.

Examples

select * from Computers where <ComputerFilter>

select Computers.Name, Applications.Name from Computers, Applications where Computers.ComputerId = Applications.ApplicationId and <ComputerFilter>

SQL Help

Please don't hesitate to visit our Forums to get assistance formulating your SQL statements.