PDQ Inventory

PDQ Inventory is a systems management tool that scans Windows computers to collect hardware, software, and Windows configuration data.

Types of Assets Fetched

This adapter fetches the following types of assets:

• Devices
• Users
  
  

The adapter parameters are as same as the SQLite adapter, which are also as same as the CSV adapter parameters, except for the File contains users information and the File contains installed software information parameters. These fields are not part of the PDQ Inventory adapter configuration.
In addition for the following parameters note:
File Name - Should contain the PDQ DB filename (i.e. database.db)
Path to Resource - Should contain the full network path with appended filename (\xxx.xxx.xxx.xxx\PDQ\database.db)


The functionality of this adapter is as same as the SQLite adapter.

Required Ports

• 135(RPC)
• 445 (SMB)
• Random port in the range 1024-65535

Setting up a fixed port for WMI

The PDQ Inventory adapter uses WMI.
You need to set up a fixed port to work with WMI.
WMI runs as part of a shared service host with ports assigned through DCOM by default. However, you can set up the WMI service to run as the only process in a separate host and specify a fixed port. For more details, see Microsoft Documentation - Setting Up a Fixed Port for WMI.

To set up a fixed port for WMI:

1. At the command prompt, type:

winmgmt -standalonehost

2. Stop the WMI service by typing:

net stop "Windows Management Instrumentation"

or:

 net stop winmgmt

3. Restart the WMI service again in a new service host by typing:

net start "Windows Management Instrumentation" 

or:

net start winmgmt

4. Establish a new port number for the WMI service by typing (e.g. the following example will establish port TCP 24158):

netsh firewall add portopening TCP 24158 WMIFixedPort

To undo any changes you make to WMI, type:

winmgmt /sharedhost

Then stop and start the winmgmt service again.

Advanced Settings

1. SQL pagination (required, default: 1000) - Set the number of results per page received for a given SQL query, to gain better control on the performance of all connections of for this adapter.
2. Do not fetch devices without a MAC address (optional) - Select to avoid fetching devices that lack MAC address information.
3. Tables to fetch (required, default: LocalGroups, LocalGroupMembers, Applications) - Select one or more tables to enrich the device's information.