Standard Report Examples

PDQ Connect collects a variety of data from your managed devices, giving you the flexibility to build reports tailored to your environment. The examples below demonstrate a few standard reports that can serve as a starting point for creating your own.
 

PDQ Connect Agent Versions Report

Use this report to identify which version of the PDQ Connect Agent is installed on each managed device and quickly find systems that may not have received the latest agent update.
Device columns (recommended)Device columns (optional)
  • Device: Agent version
  • Device: Hostname
  • Device: Last seen
  • Device: OS edition
  • Device: OS version
  • Device: SP/Release
  • Device: When added

Group the report by Agent version.

This groups devices by installed agent version, making it easy to identify systems that are running older releases. 

Grouping

The report configuration above uses grouping on the Device: Agent version column. When viewing the report, expand a version group to display all devices associated with that agent version, making it easy to identify systems running older releases.

Understanding the Results

The PDQ Connect Agent updates automatically. If a device is running an older version, the Last seen column can help explain why. Devices that have not checked in recently may not have received the latest agent update. Devices that are online and regularly checking in should typically update automatically without intervention. 
 

Windows Updates Report

Use this report to view Windows updates installed on managed devices. To access the Windows updates columns, click "Select columns," then select "Windows updates (installed)" from the drop down. 
Device columnsWindows updates columns
  • Device: Name
  • Device: OS edition
  • Device: SP/Release
  • Device: OS version
  • Windows updates (installed): Update title
  • Windows updates (installed): Update type
  • Windows updates (installed): Update date
  • Windows updates (installed): Update description
  • Windows updates (installed): Update support URL

Grouping

In this example, no columns are grouped, so all results are displayed in a tabular format.

You can optionally group the report by Hostname or Update Title. Grouping by Hostname allows you to expand a device and view all updates installed on that device. Grouping by Update Title allows you to expand an update and view all devices on which that update is installed.

Understanding the Results

This report provides a simple way to:

  • Review updates installed on a specific device
  • Review update installation dates and times
  • Compare installed updates across multiple devices

The Update date column shows when the update was installed, while the Update title and Update type columns help distinguish security updates, cumulative updates, feature updates, and other update categories.

PowerShell Scanner Report

Reports can be built using columns generated by a PowerShell scanner. The example below uses a scanner that collects Sysmon version information from managed devices.
 

Script used to create the scanner: 

if (Test-Path "C:\Windows\Sysmon64.exe") {
    $sm = (Get-Item "C:\Windows\Sysmon64.exe").VersionInfo

    [pscustomobject]@{
        ProductName = $sm.ProductName
        FileName    = $sm.FileName
        FileVersion = $sm.FileVersion
        Architecture = "64-bit"
    }
}
elseif (Test-Path "C:\Windows\Sysmon.exe") {
    $sm = (Get-Item "C:\Windows\Sysmon.exe").VersionInfo

    [pscustomobject]@{
        ProductName = $sm.ProductName
        FileName    = $sm.FileName
        FileVersion = $sm.FileVersion
        Architecture = "32-bit"
    }
}

When the scanner runs, PDQ Connect creates a new column source using the scanner name. In this example, the scanner is named Sysmon, making each returned property available as a report column.

Device columnsPowerShell > Sysmon columns
  • Device: Name
  • Sysmon: ProductName
  • Sysmon: FileVersion
  • Sysmon: Architecture
The resulting report allows you to view the Sysmon version installed across all managed devices from a single location. Similar reports can be built for virtually any data that can be collected with a PowerShell scanner, making this a powerful way to track custom software, configuration settings, compliance information, and other environment-specific details.
Was this article helpful?