Patch Policy - Next Start Time

AFAIK there is not an API endpoint for the Patch Policy component. Was curious if anyone had a method to obtain the “Start Time” for Patch Policies? I am going to parse the DB tables to validate further, but it would be beneficial for us in some capacity to be able to pull these metrics as we manage a lot of patch policies for various clients/groups. Our thoughts is this data must be set on the database somewhere and hopefully we can obtain it with a simple SQL query for now. Any feedback is greatly appreciated!

Screenshot for reference:

1 Like

Wanted to follow up here… You can leverage the following query to obtain this data:

SELECT
E.policyID,
P.name AS 'policyName',
S.name AS 'scheduleName',
triggerTime AS 'nextStartTime'
FROM
webui.apENGINEJOB E
INNER JOIN
webui.apPOLICY P
ON
P.policyID = E.policyID
INNER JOIN
webui.apSCHEDULE S
ON
S.scheduleID = E.scheduleID
WHERE
P.status = 'active'
AND
E.status = 'new'
AND
E.jobType = 'ROLLOUT';