i'm looking for SQL Query to get the patch deployment Status. Here is my senario.
Altiris 7.1 SP2 - SMS
we have aroud 1500 Servers, we have grouped them in three different group(OU) as Group 0 , 1 and 2
Group 0 contains 200 Servers
Group 1 contains 500 Servers
Group 2 contains 800 Servers.
real game beings now.
I have deployed around 30 windows updates to Group 0 and Group 1 Servers only.
Now, i would like to get the deployment status for Group 0 and Group 1 alone.
but in console the Compliance reports, shows for all the updates against all the servers.
please help me to create sql query to check the deployment status for Group 0 and Group 1 alone.
only after submitting the Group 0 and Group 1 results, i will be allowed to deploy for Group 2 Servers.