‎01-25-2013 09:25 PM
‎01-06-2015 06:30 PM
‎04-18-2014 01:59 PM
‎04-17-2014 03:33 AM
‎04-22-2013 11:24 PM
‎04-23-2013 04:54 PM
arupert wrote:
We also desperately need this functionality. Our computer names contain a location and physical asset tag number. When a computer dies, there is no way for us to find the computer name other than to search for the asset tag number that is contained in the computer name, which returns no results 😞
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetName Like '%LAN%' And tblAssetCustom.State = 1
‎01-25-2013 09:56 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now