Deployment Status SQL

Question

Hi Team.

I need to group and submit a report of all teams that are in compliant, in progress, error and unknown status, in sql can be done? The filter can be the title of the display e.g. the AssignmentName.

I was reviewing the native sccm reports but none of them meet the requirements.

Thanks for your help.

Answer 1

@Rafael Aguilar
How about this query:
select
vrs.Name0,
a.Assignment_UniqueID as DeploymentID,
a.AssignmentName as DeploymentName,
sn.StateName as LastEnforcementState
from v_CIAssignment a
join v_AssignmentState_Combined assc on a.AssignmentID=assc.AssignmentID
join v_StateNames sn on assc.StateType = sn.TopicType and sn.StateID=isnull(assc.StateID,0)
join v_R_System vrs on vrs.ResourceID = assc.ResourceID

Answer 2

Good Afternoon AllenLiu-MSFT.

Thank you very much, your help has been very useful and I hope people like you exist more.

The query served me as a base and I added other parameters and a filter.

Thank you.

Answer 3

Hello AllenLiu-MSFT.

Do you know of any courses or books that can help me with sql consultations focused on sccm?

Thank you.

Regards.