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.
M.NAME AS MACHINE_NAME,
DP.NAME AS PACKAGE,
DP.COMPONENT_DESC AS TYPE,
DIAD.VERSION AS MACHINE_VERSION,
DP.VENDOR_VERSION AS CATALOG_VERSION,
MS.APPLICABLE_UPDATE AS ACTION
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
MS.APPLICABLE_UPDATE IN ('UPGRADE')
ORDER BY M.NAME,
Be the first to answer this question