Hello all wondering if someone can help me figure out why this Query give me different results then the caned report Software Updates - A Compliance Compliance 1 - Overall Compliance pointing to same collection and Update list as below. It's probably something Easy I am just not seeing.
Select Compliant= (Select Count(r.resourceid) from v_UpdateGroupStatus_Live cs left join v_StateNames sn on sn.TopicType=300 and sn.StateID=isnull(cs.Status, 0) left join v_AuthListInfo ai ON cs.CI_ID = ai.CI_ID inner join v_R_System r ON cs.ResourceID = r.ResourceID join [v_CM_RES_COLL_XXXXXXXXX] COL on col.ResourceID = r.ResourceID where Active0 = 1 AND ai.Title = 'Updatelist' and cs.status = '3') , NONCompliant=(Select Count(r.resourceid) from v_UpdateGroupStatus_Live cs left join v_StateNames sn on sn.TopicType=300 and sn.StateID=isnull(cs.Status, 0) left join v_AuthListInfo ai ON cs.CI_ID = ai.CI_ID inner join v_R_System r ON cs.ResourceID = r.ResourceID join [v_CM_RES_COLL_XXXXXXXXX] COL on col.ResourceID = r.ResourceID where Active0 = 1 AND ai.Title = 'Udatelist' and cs.status < '3')
