The report below lists the mapped drives configured on your Windows computers. Keep in mind that Lansweeper only scans persistent mapped drives. These are the drives found in HKEY_CURRENT_USER\Network in the client machine's registry.
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 been successfully scanned at least once.
- At least one persistent mapped drive is present in the computer's registry under HKEY_CURRENT_USER\Network.
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,
tblMappedDrives.Driveletter,
tblMappedDrives.RemotePath,
tblMappedDrives.Username As DriveOfUser,
tblMappedDrives.Lastchanged As LastChanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblMappedDrives On tblAssets.AssetID = tblMappedDrives.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 tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName,
tblMappedDrives.Driveletter
