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

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.

Dynamic Collection comparing filter information

Avatar
Andrew Hoffman

I want to create a Dynamic Collection comparing filter information so I can use this list of computers as a target in deploy. In particular I'm looking to find where Computer AD Description does not equal Computer Description

I'm able to make a sql report easily for this but there's no good way to make a filter that I've been able to find. The SQL looks like this: select Computers.Name as "Computer Name" from Computers where Computers.Description not like Computers.ADDescription and Computers.IsOnline = true

Ultimately my goal is that Deploy will run the Powershell script to sync this information from AD to the Workstation Daily but only for workstations where the information is wrong. I don't like to just blindly apply.

Is there a good way to do this?

0

Comments

0 comments