SQL - Today's total patch attempts

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 total patch attempts

Post by Cubert »

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

Post Reply

Return to “Scripts”