Month: September 2009

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