SQL - Today's successful patch count
Posted: Sat Jan 15, 2022 4:00 pm
Today's successful patch count
Code: Select all
SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts'
FROM commands
WHERE command = 100 AND `status` = 3
AND output LIKE '%downloaded and installed successfully%'
AND dateupdated >=CURDATE()