Create a report for overall update compliance for deployments with a deadline (Now()-MaxDays < Deadline Date < Now()-MinDays) for clients that are active and healthy (they have status "active/pass") belonging to a selected collections. If there are more than onde deployments for the clients its their status in the report is set to the worst one. All possible statuses, from the worst to the best, are: "Unknown"-> "Not Compliant" -> "Compiant".
SOLUTION:
The required report has three parameters:
- Collection ID (e.g. 'SMS000001')
- MaxDays (e.g. 30)
- MinDays (e.g. 7)