SQL - Today's total patch attempts
Posted: Sat Jan 15, 2022 3:59 pm
Today's total patch attempts
Code: Select all
SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts'
FROM commands
WHERE command = 100 AND `status` = 3
AND dateupdated >=CURDATE()