How can I get a report of current bios version on system and most recently released BIOS version from Dell?
-
Are you using the Dell Updates Module for the deployment? The Catalog shows you all of the updates that are available. - Desktop Jockey 6 years ago
Answers (2)
I know this thread is 5 years old, but in case anyone comes searching for an answer like I did.
I couldn't get this working with the built-in report assistant, so I had to build a report with a custom SQL query. Mine looks like this :
SELECT ORG1.MACHINE.NAME AS SYSTEM_NAME, ORG1.MACHINE.CS_MODEL AS 'Model', ORG1.MACHINE.BIOS_VERSION AS 'Current BIOS Version', RIGHT(KBSYS.HW_UPDATE.TITLE, 6) AS 'Newest BIOS Version', KBSYS.HW_UPDATE.CREATION_DATE AS 'Release Date'
FROM KBSYS.HW_UPDATE_MODELS
JOIN KBSYS.HW_UPDATE ON KBSYS.HW_UPDATE_MODELS.HW_UPDATE_ID=KBSYS.HW_UPDATE.ID
RIGHT JOIN ORG1.MACHINE ON KBSYS.HW_UPDATE_MODELS.MODEL_NUMBER=ORG1.MACHINE.CS_MODEL
WHERE KBSYS.HW_UPDATE.PATCH_TYPE LIKE 'BIOS'
GROUP BY ORG1.MACHINE.NAME
ORDER BY ORG1.MACHINE.CS_MODEL, INET_ATON(ORG1.MACHINE.BIOS_VERSION) DESC
I'm sure the query could be improved but I'm a novice when it comes to SQL and it's enough for what I needed.
