How to create a report that shows computers with a Managed Install enabled from a Replication Share (4285585)

CODE WRITTEN BY KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT.   CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSIBILITY FOR USE  AND MISUSE OF CODE. KACE SHALL NOT BE HELD LIABLE FOR DAMAGE OR DOWN TIME RESULTING  FROM USE OF THIS OR ANY CODE PRESENTED FOR PURPOSES OF TROUBLESHOOTING OR DEMONSTRATION.

1. Click Reporting and then from Choose Action select
2. In the Choose Action menu, click New Report (SQL).
3. Fill out the Title, Description, Category, and then enter the following into the SQL query field:

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

Click Save and from the Report list generator the report.

Disclaimer: