SQL Query for collection creation date, deployment name and enforcement state of endpoints


Hello HTMDians,

Help needed from all SQL Guru’s in our forum.

  1. 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.

solved 0
Deepak Rai 4 months 2021-10-09T02:47:29+05:30 2 Answers 45 views Admin 0

Answers ( 2 )


    Ok Sir. Will check with Karthik and if this requirement is fulfilled then going to share here.

  1. I think @Karthick is the best to help you here. Can you try to email him with this thread?

    Best answer
    Cancel the best answer

Leave an answer

Sorry, you do not have a permission to answer to this question .