SQL Query for collection creation date, deployment name and enforcement state of endpoints
Help needed from all SQL Guru’s in our forum.
- I have been trying to write one SQL Query where i need to fetch the compliance of the collection along with the enforcement state of each servers inside the collection and maintenance window. And this is not it. I am also trying to get all the collections created on specific date along with the deployment targeted to it and the status of the deployment for each client it has been deployed to i.e Compliant, Non-Compliant, Failed to install update. The subscription should get the maintenance window from the collection and send the enforcement at the end of the maintenance window.
Open to everything like PS, SSRS, PowerBi, Teraform, Azure Runbook automation. etc.
My current setup.
1 Primary, 4 MP, 3 HTTP and 1 HTTPS MP, CMG, 43 DP’s, 41 HTTP and 2 HTTPS (CDP included). 2 SUP, 1 HTTP and another one HTTPS.