Create a report that shows computers with a Managed Install enabled from a Replication Share (114237)

Retour
  • Titre

    Create a report that shows computers with a Managed Install enabled from a Replication Share
  • Description

    This articles shows how to create a SQL report that shows Managed Installations assigned to computers on a particular replication share.
  • Résolution

    CODE WRITEN BY DELL KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT.   CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSABILITY FOR USE  AND MISUSE OF CODE. DELL 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.



Produit(s) :
K1000 Systems Management Appliance
5.5.x, 5.4.76847, 5.4.70402, 5.3.53053

Sujet(s) :
How To

Historique de l’article :
Créé le : 9/20/2013
Dernière mise à jour le : 8/12/2014

Feedback submitted.

Cet article vous a-t-il aidé ?

[Select Rating]

Thank you for your rating!

Close

Demander ou créer un article de la base de connaissances »