‎11-09-2017 08:47 AM
‎11-10-2017 03:50 PM
‎11-09-2017 07:37 PM
SELECT Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Office,
-- short form of OS name
tsysOS.OSname,
-- alternatively, more details
tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion,
tblOperatingsystem.ServicePackMinorVersion,
tblOperatingsystem.Version
FROM
tblAssets
INNER JOIN tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
LEFT JOIN tblADusers On tblAssets.Username = tblADusers.Username And tblAssets.Userdomain = tblADusers.Userdomain
INNER JOIN tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
INNER JOIN tsysOS On tblAssets.OScode = tsysOS.OScode
WHERE
tblAssetCustom.State = 1
‎11-09-2017 11:56 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now