Latest Posts

SQL Query to list all the systems with OS & BIOS Version details


Select
comp.Name0 as [Machine Name],
comp.Manufacturer0 as [Manufacturer],
comp.Model0 as [Model],
bios.SerialNumber0 as [Serial Number],
bios.SMBIOSBIOSVersion0 as [BIOS Version],
comp.UserName0 as [User Name],
ops.Caption0 as [Operating System],
ops.CSDVersion0 as [Service Pack],
ops.Version0 as [OS Version],
ops.InstallDate0 as [OS Installed Date]
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

 

Output:

Capture

Advertisements

2 Comments on SQL Query to list all the systems with OS & BIOS Version details

  1. Thanks for this. It came in handy today.

    Like

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s