Filter

The category of data to be filtered, for example, Application, Computer, Hot Fix, Local Group, and Service.

Column

The column to compare with the value. Each property of a computer and its inventory is represented as a column, for example, AD Last Logon, Collection, Current User, and Model. The columns you have to choose from are determined by the Filter selected.

Comparison

How the column is compared to the value. The comparisons you have to choose from are determined by the Column selected.

There are five different comparison types available, each with their own rules and value types. For example, when comparing versions (for example, Application Version), refer to the Versions in the Text Columns section.

Available values:

Boolean

Boolean fields are the simplest type of field. They match a value using Is True or Is False.

Collection

Collection fields are only used for the Collection column filter. They filter for whether a computer is (Is Member) or is not a member (Is Not Member) of the selected collection. The collection column will continue to reference a collection, even if it is renamed or moved.

NOTE: Exporting a collection and importing it into another installation of PDQ Inventory may not work properly if there isn't a matching collection already in the new database.

Date/Time

Date/Time fields match against a date/time value in the database, for example, the Boot Time or Operating System Install Time. There are two ways to match a date time, fixed and relative.

Fixed Date
A fixed date filters against a specific date/time. When dates are entered without a time they are treated as midnight on that date. To match a whole day (for example, all computers booted on January 1st, 2011), use the Between comparison and enter "1/1/2011" and "1/2/2011".

Relative Date
Relative dates match a date/time based on the current date and time. Relative matches can be in the past or the future. For example, to get all computers rebooted in the last 24 hours enter "1 Day Ago".

To see computers that have been added to or removed from a collection based on the relative time changing you will need to refresh the collection.

PDQ Inventory uses a 12-hour clock instead of a 24-hour clock. For example, 12:00:00 AM is midnight (or 00:00:00 on the 24-hour clock), while 12:00:00 PM is noon (or 12:00:00 on the 24-hour clock).

Integer

Integer fields match against numeric values which are whole numbers. For example, the number of megabytes of memory installed on a computer.

Text

Text fields match against a text value such as the name or description of a computer.

Versions
Use one of the version comparisons (for example, Version Equals and Version Not Higher Than), to match against version numbers in text values. This is particularly helpful with the Application and File scanners.

Version matches use the following rules:

•Versions are numbers separated by dots or commas. For example, 10.1.15 and 1,3,4 or 55 are acceptable version numbers.

•Versions compare left to right as whole numbers within the delimiters. For example, 1.15 is considered to be higher than 1.5, which is different than if comparing based solely on text.

•Any missing values are treated as zeros. For example, 4.65.00.0 is considered equal to 04.65.

•Versions can appear anywhere in the text value. For example, "Ver. 1.5.2 (Dec 15)" is treated as "1.5.2" for purposes of comparison.

•When entering the version to compare against, only include the version number. For example, "Ver 1.5.2" is not a valid version.

Patterns
When using the Matches Pattern and Does Not Match Pattern comparisons you can use wildcards, similar to matching file names on the command line.

•[ * ] Matches zero or more characters.

For example, workstation* matches workstation, workstation1, and workstation999.

•[ ? ] Matches any single character.

For example, workstation?? matches workstation99 but not workstation or workstation999.

For example, workstation?** matches workstation1 and workstation99 but not workstation.

Regular Expression
Regular expressions allow for sophisticated matching of text using patterns. Writing good regular expressions is a complicated topic. For links to some excellent information about regular expressions, see our Regular Expression Resources support page.

As always, feel free to reach out on Discord for some help creating expressions.

Value

The value to match against (depends on the comparison selected). For details about the different value field types, see the comparison types above.

Some matches use multiple values (for example, between two different dates). Some value types include controls on the right side of the field that allow you to look up or edit the value.

TIP: Use variables whenever possible as values. See Variables in Value Filters.