//
you're reading...
Uncategorized

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 as [Machine Name],
Comp.Manufacturer0 as [Manufacturer],
Comp.Model0 as [Model],
Ops.Caption0 as [Operating System]

FROM
v_GS_COMPUTER_SYSTEM comp join
v_GS_OPERATING_SYSTEM ops on ops.ResourceID=comp.ResourceID join
v_GS_PC_BIOS bios on bios.ResourceID=comp.ResourceID

WHERE
(Comp.Manufacturer0 LIKE ‘%HP%’OR comp.Manufacturer0 LIKE ‘%Hewlett-Packard%’) AND comp.model0 NOT like ‘%ProLiant%’

ORDER BY Comp.Name0, Comp.Manufacturer0, Comp.Model0, Bios.SerialNumber0, Bios.SMBIOSBIOSVersion0, Ops.Caption0


Result

SQL_Query

 

Advertisements

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Advertisements
%d bloggers like this: