This query will show you which machines have maxed out on their attempts to install a peice of software. It will show you the name of the software and whether the Managed Install is still enabled or not
select M.NAME,S.DISPLAY_NAME, ATTEMPT_COUNT, IF(MI.ENABLED>0,'enabled','disabled') ENABLED from
SOFTWARE S JOIN
MI ON S.ID=MI.SOFTWARE_ID
JOIN MI_ATTEMPT A ON MI.ID=A.MI_ID
JOIN MACHINE M ON M.ID=A.MACHINE_ID
WHERE
ATTEMPT_COUNT>=MAX_ATTEMPT_COUNT
It is recommend that you run this as a schedule report. If you are in version 5.0 then you can import the attached kpkg.