Code: Select all
SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts'
FROM commands
WHERE command = 100 AND `status` = 3
AND dateupdated >=CURDATE()
Code: Select all
SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts'
FROM commands
WHERE command = 100 AND `status` = 3
AND dateupdated >=CURDATE()