SQL - Today's successful patch count

Useful script s and methods to resolve complicated issues in ConnectWise Automate
Post Reply
User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

SQL - Today's successful patch count

Post by Cubert »

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

Post Reply

Return to “Scripts”