Introduction to Filters & Groups

Filters allow you to organize and sort your devices in PDQ Connect. Filters can be applied to the Devices page once for a quick view of the devices that meet the filter criteria, or they can be saved as a Group for repeated viewing and targeting in deployments. 

To learn about the logic used when configuring Filters & Groups, see Filtering Logic Explained

Configuring Filters

Create Filter.png
  • To create a new filter, select Filter while viewing the Devices page, or Create Group with the Groups menu expanded.
  • Configure your desired filters and click Apply to apply the filters to the Devices page or Save as Group to save the configured filters as a new Device Group. 
  • When a Filter is applied to the Device page, or when viewing a Group, a number will appear over the Filter button, indicating the number of applied filters. 

 

Filter Menu Options

Filter Menu.png
  • Add Filter: Adds an additional Filter to the main Filter Group. 
  • Add Filter Group: Creates a new Filter Group, nested in the main Filter Group. 
  • Clear Filters: Clears all the configured Filters. 
  • Save as Group: Saves the configured Filters as a new Device Group.
  • Apply: Applies the configured Filters to the Devices page. 

 

Filter Groups

Filter Groups are groups of Filters that use the OR, AND, NOR, and NAND logic gates to determine how the Filter Groups are to be evaluated together. Filter Groups can be nested to create complex filters with increasing granularity.

Filter Groups.png
  • Click ++ in the Filter Menu to add a new filter Group. 
  • Configure the logic gate AND, OR, NAND, or NOR to the left of the new Filter Group to determine how the Filter Group will be evaluated against the other Filters and / or Filter Groups. 
  • Within a Filter Group, click the + to add a new Filter to the Filter Group or click the ++ to add a new Filter Group within the Filter Group. 
  • Within a Filter Group, configure the logic gate AND, OR, NAND, or NOR to the left of the Filters to determine how the Filters will be evaluated within the Filter Group.

 

Absolute and Relative Date Filtering

For any value which can be expressed using a specific date:

Item Date value
Device Last seen, OS install date, When added
Drivers Release date
Files and folders Object created at, Object modified at
Software Install date
Windows updates Update date


It's possible to create a filter which compares that date to a specific, known value, and includes all devices which exist before, after, or equal to (is) that value, or if the value is/is not empty.

It is also possible to select a comparison relative to today. For example, here is a filter which would display all devices last seen 30 days or longer from the current date.

Groups which make use of relative date filters will be recalculated when a new date begins at 00:00 UTC, irrespective of which time zone the device exists in. For example, on US East Coast Standard time (EST, UTC -05:00) the groups would recalculate around 7:00 PM and devices will be added/removed. If based in the UK, the recalculation would take place around midnight (GMT, UTC +00:00) and so on.

Variables

PDQ Inventory comes with pre-defined Variables that can be used within Filters & Groups. The Variables in PDQ Connect are the same Variables included in the PDQ Inventory Collection Library and are updated by the PDQ Packaging Team to reflect the application names, versions, publishers, etc..., as Package Library Packages are updated. 

  • $(AppName_) - Application Name - The application name, as it appears in Programs & Features
  • $(AppPub_) - Application Publisher - The Publisher of the application
  • $(AppVer_) - Application Version - The latest version of the application
  • $(Date) - Current Date
  • $(HFName_) - Hot Fix Name (Updated to the latest Cumulative update KB# for a specific OS)
  • $(OSVer_) - OS Version (The full latest version number for a specific OS build)
  • $(RTName_) - Runtime Name - Used with Runtimes such as Java, .NET
  • $(RTVer_) - Runtime Version - The latest version of the Runtime

Filter & Group Examples

Example 1: Finding devices by the device name.

Example 2: Devices with Google Chrome installed. 

Example 3: Devices without Google Chrome installed.  

Example 4: Devices, excluding servers, without Google Chrome installed.

Example 5: Devices with the latest version of Google Chrome installed. 

Example 6: Devices with an older version of Google Chrome installed. 

Old Chrome.png

Example 7: Devices that have not been seen in the last 30 days. 

Example7.2.png

Example 8: Devices with a specific file modified in the last two weeks (requires Files & Directories Scanner). 

Example8.2.png
Still have a question or want to share what you have learned? Visit our Community Discord to get help and collaborate with others.