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()
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()