KACE Product Support

I dont understand why when kace releases new db Schemas they would at least provide us with the proper syntax for their built in scripts.  

Ive figured out part of this but cant seem to figure out the catalog part. I think DELL_MACHINE_STATUS is HW_UPDATE_MACHINE_STATUS.

SELECT

M.NAME AS MACHINE_NAME,          

DP.NAME AS PACKAGE,      

DP.COMPONENT_DESC AS TYPE,      

DP.CRITICALITY,      

DIAD.VERSION AS MACHINE_VERSION,      

DP.VENDOR_VERSION AS CATALOG_VERSION,      

MS.APPLICABLE_UPDATE AS ACTION 

FROM

DELL_MACHINE_STATUS  MS 

JOIN MACHINE M ON M.ID=MS.MACHINE_ID 

JOIN KBSYS.DELL_PKG DP ON DP.DELL_CATALOG_ID=MS.CATALOG_ID AND DP.PACKAGE_DID=MS.PACKAGE_DID 

JOIN DELL_PKG_STATUS DPS ON DPS.DELL_PKG_ID=DP.ID AND DPS.STATUS=0 

JOIN DELL_INVENTORY_APPLICATION_DEVICE_JT DIAD ON DIAD.DEVICE_ID=MS.DEVICE_ID

WHERE 

MS.APPLICABLE_UPDATE IN ('UPGRADE') 

ORDER BY M.NAME,      

DP.COMPONENT_DESC,      

DP.NAME