Dynamic Collection comparing filter information
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?