Count of ARP by sitecode

SELECT
    v_BoundaryInfo.SiteCode,
    V_ADD_REMOVE_PROGRAMS.DisplayName0,
    Count(*)
FROM
    v_R_System_valid,
    v_BoundaryInfo,
    V_ADD_REMOVE_PROGRAMS
WHERE
    v_R_System_valid.ResourceID = V_ADD_REMOVE_PROGRAMS.ResourceID
    AND V_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE ‘%office%’
    AND v_R_System_valid.AD_Site_Name0 = v_BoundaryInfo.value
GROUP BY
    v_BoundaryInfo.SiteCode,
    V_ADD_REMOVE_PROGRAMS.DisplayName0

Leave a Reply

Your email address will not be published. Required fields are marked *