CountMissingPatchesByMachineForClient.sql

SELECT clients.name AS 'ClientName',comp.name AS 'ComputerName', COUNT(H.installed) AS '# Patches Missing',comp.lastcontact AS 'Last Checked In' 
  FROM hotfix AS H, computers AS comp, clients
	  WHERE H.installed=0 
	    AND H.approved=1 
	    AND comp.computerid=H.computerid 
	    AND comp.clientid=clients.clientid 
	    AND comp.clientid=220 
	      GROUP BY comp.name 
	      ORDER BY comp.lastcontact DESC