Windows: Harddrive Serial Number (Built-in)

[Daniel_B]

Old name: Asset: Harddrive Serial Number (Built-in)

The report below gives back a list of serial numbers of physical hard disk drives of windows computers
The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer
  
• The computer's state is set to 'Active'
  
• The computer has a serial number
  
• The computer has been successfully scanned at least once

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblFloppy.SerialNumber,
  tblFloppy.Manufacturer As HDManufacturer,
  tblFloppy.Model As HDModel,
  Cast(tblFloppy.Size / 1024 / 1024 / 1024 As int) As SizeGB,
  tblFloppy.FirmwareRevision,
  tblFloppy.Status
From tblFloppy
  Inner Join tblAssets On tblFloppy.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFloppy.Status Is Not Null And tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName