/build/static/layout/Breadcrumb_cap_w.png
06/11/2019 206 views

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

Comments


There are no answers at this time