SCCM

HP Machines and BIOS version Report

I was asked by my Project Manager to generate a report for HP machines (desktop and laptops) that lists Hosts names, Hardware Model, BIOS version and Operating System version. I Run the Query below SQL Management Studio and saved the result to a CSV file: SELECT Bios.SerialNumber0 as [Serial Number], Bios.SMBIOSBIOSVersion0 as [BIOS Version], Comp.Name0 … Continue reading →