我使用下面的查询根据上一个强制执行截止日期（过去24小时）提取部署状态，

SELECT vrs.name0
    ,a.EnforcementDeadline
    ,sn.StateName AS LastEnforcementState
FROM v_CIAssignment a
JOIN v_AssignmentState_Combined assc ON a.AssignmentID = assc.AssignmentID
JOIN v_StateNames sn ON assc.StateType = sn.TopicType
    AND sn.StateID = isnull(assc.StateID, 0)
JOIN v_R_System vrs ON vrs.ResourceID = assc.ResourceID
WHERE DATEDIFF(DAY, a.EnforcementDeadline, getdate()) = 1

是否可以根据集合维护窗口的开始时间提取部署状态？