Grâce à l'appliance Dell KACE, les tâches réalisées auparavant par trois ou quatre personnes ne nécessitent maintenant que deux d'entre elles.
Bryon Black, South Coast Water District

Managed Installs that have hit their Max Attempts Count

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.