sql server—如何编写sql查询以根据维护窗口开始时间而不是强制执行截止时间来获取sccm部署状态

xeufq47z 于 2021-07-27 发布在 Java

关注(0)|答案(0)|浏览(146)

我使用下面的查询根据上一个强制执行截止日期（过去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

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

sql sql-server ssms reporting-services sccm

来源：https://stackoverflow.com/questions/63159322/how-to-write-sql-query-to-pull-sccm-deployment-status-based-on-maintenance-windo