I was given this query and asked to turn it into a report for subscription:
v_R_System inner join v_G_System_DCMDeploymentState on v_G_System_DCMDeploymentState.ResourceID = v_R_System.ResourceId WHERE BaselineID = 'ScopeId_xxxxxxxxxxxxxxxxxxxx' AND CollectionID = xxxxxx' AND ComplianceState = 3
I've tried to find BaselineID, but don't see it any views. Was this changed? I also don't see a similarly named view for DeploymentState, unless v_CICurrentComplienceStatus is it?!? Any suggestions are greatly appreciated.