‎07-04-2013 05:51 PM
Solved! Go to Solution.
‎07-08-2013 03:20 PM
UPDATE tblassets
SET Assettype = (SELECT assettype FROM tsysAssetTypes WHERE AssetTypename like '%thin%'),
AssetTypeLock = 1
WHERE (SELECT model FROM tblAssetCustom c WHERE c.AssetID = tblassets.AssetID) = 'LPT1'
UPDATE tblAssetCustom
SET Model = 'C30LE',
ModelLock = 1
WHERE Model = 'LPT1'
‎07-08-2013 03:20 PM
UPDATE tblassets
SET Assettype = (SELECT assettype FROM tsysAssetTypes WHERE AssetTypename like '%thin%'),
AssetTypeLock = 1
WHERE (SELECT model FROM tblAssetCustom c WHERE c.AssetID = tblassets.AssetID) = 'LPT1'
UPDATE tblAssetCustom
SET Model = 'C30LE',
ModelLock = 1
WHERE Model = 'LPT1'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now