/build/static/layout/Breadcrumb_cap_w.png

KACE Report to find a machines dell update "Updated State"

I would like to know the following information about a list of devices (label name) and I just can't seem to get it right.

Package / Type / Criticality / Machine Ver / Catalog Ver / Action with Machine name and list of Dell Updates.

I'm close - but not close enough.  I would like to know if the device has been updated as well.  My SQL only shows if it needs an update (upgrade/downgrade).  Also - I cant figure out where to add a label name so I can just see the devices I want in a label.

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','DOWNGRADE') ORDER BY M.NAME,DP.COMPONENT_DESC,DP.NAME

Thanks everyone who sees this and helps - I'm still new to scripting!

Thanks ~Wes


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