1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Deploy
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

LAPS: update all packages to default to "Use PDQ Inventory Scan User..."?

Avatar
Michael Yorke

Hi,

I have recently deployed LAPS in our environment and keen to use this with PDQ. I have PDQ Inventory scanning machines successfully using LAPS. 

In order for PDQ Deploy to leverage this, I understand I need to check the box "Use PDQ Inventory Scan User..." taken from https://help.pdq.com/hc/en-us/articles/115001132352-LAPS-Integration-with-PDQ-Inventory-and-PDQ-Deploy

Also, this article (https://help.pdq.com/hc/en-us/articles/360033877651-Adding-and-Using-Multiple-Credentials-in-PDQ) mentions the same things, but says "Note: This selection is saved for use the next time you start a new deployment with this window."

Therefore I assume this check box value is stored in the PDQ Deploy database...? Is it possible to script a change to the database to update all my deployments (100+) and schedules (80+) to have this check box ticked? Rather than doing it manually?

Many thanks in advance.

0

Comments

2 comments
Date Votes
  • Avatar
    Colby Bouma

    Is it possible to script a change to the database to update all my deployments (100+) and schedules (80+) to have this check box ticked? Rather than doing it manually?

    TL;DR: Yes...mostly.

     

    For new deployments, the Deploy Once window uses the value stored in the following registry key. This is how it remembers your previous choice. You shouldn't need to manually change this one.

    HKEY_CURRENT_USER\SOFTWARE\Admin Arsenal\PDQ Deploy Console\UISettings\DeploymentWindow\UsePDQInventoryScanUser

     

    If you Redeploy a deployment, it uses the UsePDQInventoryUser field from the Deployments table in the database. If you really want to change this, then:

    • Go to Options --> Preferences --> Database
    • Back up your database
    • Click "SQLite Console"
    • Execute the following query: 
      UPDATE Deployments SET UsePDQInventoryUser = 1;
    • Refresh the Deploy console

     

    Existing Schedules are very similar. They use the UsePDQInventoryUser field of the Schedules table. To update them, follow the same steps as above, but use the following query. Also, you may need to restart the Background Service.

    UPDATE Schedules SET UsePDQInventoryUser = 1;

     

    Unfortunately, new Schedules always default that checkbox to false. They do not have a matching registry entry. Creating it doesn't do anything. However, you could create a template Schedule and duplicate it instead of using New Schedule. But at that point it's probably easier to just click the checkbox :)

    0
  • Avatar
    Michael Yorke

    Colby Bouma, perfect! I have run all these and they are working as expected. I'll keep an eye out for any issues.

    Many thanks!

    0