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!
Be the first to answer this question