KACE et Desktop Authority : Suite de gestion des systèmes simple d’utilisation, complète et abordable.

Any machine for a particular remote site is enabled to deploy a particular Managed Install

To find out if any machine for a particular remote site is enabled to deploy a particular Managed Install (MI)

SELECT L.NAME REPLABEL, DOWNLOAD_DIR, S.DISPLAY_NAME  MI_SOFTWARE, IF(MI.ENABLED>0,'Enabled','Disabled') MI_STATE, M.NAME MACHINE, IF(LEFT(L2.NAME,3)='HDN','No Label - Directly Assigned',L2.NAME) MILABEL FROM REPLICATION_SHARE R
JOIN LABEL L ON R.LABEL_ID=L.ID
JOIN MACHINE_LABEL_JT ML ON ML.LABEL_ID=L.ID
JOIN MACHINE M ON M.ID=ML.MACHINE_ID
JOIN MACHINE_LABEL_JT ML2 ON ML2.MACHINE_ID=M.ID
JOIN LABEL L2 ON L2.ID=ML2.LABEL_ID
JOIN MI_LABEL_JT MIL ON MIL.LABEL_ID=L2.ID
JOIN MI ON MI.ID=MIL.MI_ID
JOIN SOFTWARE S ON MI.SOFTWARE_ID=S.ID
WHERE L.NAME='%Change_Replication_Label_Here%'
and S.DISPLAY_NAME LIKE '%Change_MI_Name_here%'
ORDER BY L.NAME ASC, S.DISPLAY_NAME ASC, MI_STATE