Jetzt Ausprobieren

Hard Disk Serial Number

Hardware Hardware Components

Find All the Hard Drive Serial Numbers in Your Network

Get serial numbers without the need of opening enclosures. When disks are scanned, details such as model, manufacturer, size, firmware and also serial number are scanned. This information can save a lot of otherwise wasted time by having to physically go to machines and opening them to find a hard drive serial number. Lansweeper just all of them in one overview. Harddrive Serial Number

Hard Drive Serial Number Query

Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblFloppy.SerialNumber,
  tblFloppy.Model As [HD Model],
  tblFloppy.Manufacturer As [HD Manufacturer],
  tblFloppy.Size,
  tblFloppy.FirmwareRevision,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblFloppy
  Inner Join tblAssets On tblFloppy.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblFloppy.SerialNumber Is Not Null
Order By tblAssets.AssetName

Show

Hide