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