I have some machines on my core which obviously have a corrupt local db. These machines are online but still all policies have a "waiting" status.
I've written a batch to fix this (using clientdbutil.exe). After pushing the batch-package to the client everything works fine again (all waiting policies start to run).
I want to automate this process now. What i need is a query which lists all machines, which have >x policies assigned/waiting.
Is this possible?
Thanks a lot & best regards,