SELECT     TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, 
                      DATEDIFF(Day, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, GETDATE()) AS [days since installed]
FROM         dbo.v_R_System INNER JOIN
                      dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID
GROUP BY dbo.v_R_System.Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, DATEDIFF(Day, 
                      dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, GETDATE())
HAVING      (DATEDIFF(Day, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, GETDATE()) > 0 AND DATEDIFF(Day, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, 
                      GETDATE()) < 7)