Here are just some queries to get baseline result for each computer in the collection.
You need to replace AssignmentUniqueID and TargetCollectionID with the actual deployment unique ID and collection ID.
–Compliant
select all
AssetDetails.AssetName,
__MDeploymentCompliantStatus0.Assets,
__MDeploymentCompliantStatus0.AssignmentID,
__MDeploymentCompliantStatus0.AssignmentUniqueID,
__MDeploymentCompliantStatus0.BL_ID,
__MDeploymentCompliantStatus0.BLName,
__MDeploymentCompliantStatus0.BLRevision,
__MDeploymentCompliantStatus0.CI_ID,
__MDeploymentCompliantStatus0.CIName,
__MDeploymentCompliantStatus0.DeploymentTime,
__MDeploymentCompliantStatus0.Revision,
__MDeploymentCompliantStatus0.StatusType,
__MDeploymentCompliantStatus0.SummarizationTime,
__MDeploymentCompliantStatus0.SummaryType,
__MDeploymentCompliantStatus0.TargetCollectionID
from fn_DCMDeploymentCompliantStatus(1033)
AS __MDeploymentCompliantStatus0
join fn_dcmdeploymentcompliantassetdetails(1033)AS AssetDetails
on __MDeploymentCompliantStatus0.AssignmentUniqueID = AssetDetails.AssignmentUniqueID
AND __MDeploymentCompliantStatus0.TargetCollectionID = AssetDetails.TargetCollectionID
WHERE (__MDeploymentCompliantStatus0.AssignmentUniqueID = N'{B2EFBFFE-60DC-43C3-889F-3DADAC8355A8}’AND __MDeploymentCompliantStatus0.TargetCollectionID = N’SMS00001′)
–Error
select all AssetDetails.AssetName,
SMS_DCMDeploymentErrorStatus.Assets,
SMS_DCMDeploymentErrorStatus.AssignmentID,
SMS_DCMDeploymentErrorStatus.AssignmentUniqueID,
SMS_DCMDeploymentErrorStatus.BL_ID,
SMS_DCMDeploymentErrorStatus.BLName,
SMS_DCMDeploymentErrorStatus.BLRevision,
SMS_DCMDeploymentErrorStatus.CI_ID,
SMS_DCMDeploymentErrorStatus.CIName,
SMS_DCMDeploymentErrorStatus.DeploymentTime,
SMS_DCMDeploymentErrorStatus.ErrorCode,
SMS_DCMDeploymentErrorStatus.ErrorDescription,
SMS_DCMDeploymentErrorStatus.ErrorType,
SMS_DCMDeploymentErrorStatus.ErrorTypeDisplay,
SMS_DCMDeploymentErrorStatus.ObjectDescription,
SMS_DCMDeploymentErrorStatus.ObjectID,
SMS_DCMDeploymentErrorStatus.ObjectName,
SMS_DCMDeploymentErrorStatus.ObjectType,
SMS_DCMDeploymentErrorStatus.ObjectTypeName,
SMS_DCMDeploymentErrorStatus.Revision,
SMS_DCMDeploymentErrorStatus.RuleStateDisplay,
SMS_DCMDeploymentErrorStatus.StatusType,
SMS_DCMDeploymentErrorStatus.SummarizationTime,
SMS_DCMDeploymentErrorStatus.SummaryType,
SMS_DCMDeploymentErrorStatus.TargetCollectionID
from fn_DCMDeploymentErrorStatus(1033)
AS SMS_DCMDeploymentErrorStatus
join fn_DCMDeploymentErrorAssetDetails(1033)AS AssetDetails
on SMS_DCMDeploymentErrorStatus.AssignmentUniqueID = AssetDetails.AssignmentUniqueID
AND SMS_DCMDeploymentErrorStatus.TargetCollectionID = AssetDetails.TargetCollectionID
WHERE (SMS_DCMDeploymentErrorStatus.AssignmentUniqueID = N'{B2EFBFFE-60DC-43C3-889F-3DADAC8355A8}’AND SMS_DCMDeploymentErrorStatus.TargetCollectionID = N’SMS00001′)
–Non-Compliant
select all AssetDetails.AssetName,
__ploymentNonCompliantStatus0.Assets,
__ploymentNonCompliantStatus0.AssignmentID,
__ploymentNonCompliantStatus0.AssignmentUniqueID,
__ploymentNonCompliantStatus0.BL_ID,
__ploymentNonCompliantStatus0.BLName,
__ploymentNonCompliantStatus0.BLRevision,
__ploymentNonCompliantStatus0.CI_ID,
__ploymentNonCompliantStatus0.CIName,
__ploymentNonCompliantStatus0.DeploymentTime,
__ploymentNonCompliantStatus0.IsBaselineRule,
__ploymentNonCompliantStatus0.Revision,
__ploymentNonCompliantStatus0.Rule_ID,
__ploymentNonCompliantStatus0.RuleDescription,
__ploymentNonCompliantStatus0.RuleName,
__ploymentNonCompliantStatus0.RuleSeverity,
__ploymentNonCompliantStatus0.RuleStateDisplay,
__ploymentNonCompliantStatus0.RuleSubState,
__ploymentNonCompliantStatus0.StatusType,
__ploymentNonCompliantStatus0.SummarizationTime,
__ploymentNonCompliantStatus0.SummaryType,
__ploymentNonCompliantStatus0.TargetCollectionID,
__ploymentNonCompliantStatus0.ValidationRule
from fn_DCMDeploymentNonCompliantStatus(1033)AS __ploymentNonCompliantStatus0
join fn_DCMDeploymentNonCompliantAssetDetails(1033)AS AssetDetails
on __ploymentNonCompliantStatus0.AssignmentUniqueID = AssetDetails.AssignmentUniqueID
AND __ploymentNonCompliantStatus0.TargetCollectionID = AssetDetails.TargetCollectionID
WHERE (__ploymentNonCompliantStatus0.AssignmentUniqueID = N'{B2EFBFFE-60DC-43C3-889F-3DADAC8355A8}’AND __ploymentNonCompliantStatus0.TargetCollectionID = N’SMS00001′)
–Unknown
select all AssetDetails.MachineName,
SMS_CIDeploymentUnknownStatus.AssignmentID,
SMS_CIDeploymentUnknownStatus.AssignmentUniqueID,
SMS_CIDeploymentUnknownStatus.Category,
SMS_CIDeploymentUnknownStatus.CI_ID,
SMS_CIDeploymentUnknownStatus.CollectionID,
SMS_CIDeploymentUnknownStatus.CollectionName,
SMS_CIDeploymentUnknownStatus.DeploymentIntent,
SMS_CIDeploymentUnknownStatus.PolicyModelID,
SMS_CIDeploymentUnknownStatus.SoftwareName,
SMS_CIDeploymentUnknownStatus.StartTime,
SMS_CIDeploymentUnknownStatus.Total
from fn_CIDeploymentUnknownStatus(1033)
AS SMS_CIDeploymentUnknownStatus
join fn_CIDeploymentUnknownAssetDetails(1033)AS AssetDetails
on SMS_CIDeploymentUnknownStatus.AssignmentUniqueID = AssetDetails.AssignmentUniqueID
AND SMS_CIDeploymentUnknownStatus.CollectionID = AssetDetails.CollectionID
WHERE (SMS_CIDeploymentUnknownStatus.AssignmentUniqueID = N'{B2EFBFFE-60DC-43C3-889F-3DADAC8355A8}’AND SMS_CIDeploymentUnknownStatus.CollectionID = N’SMS00001′)
SCCM Monde 