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.
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
