/build/static/layout/Breadcrumb_cap_w.png

Dell driver report - new schema for canned report

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


0 Comments   [ + ] Show comments

Answers (0)

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ