03-14-2013 04:05 PM
Solved! Go to Solution.
03-22-2013 06:05 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssetCustom.Serialnumber,
tblAssets.IPAddress,
tblAssetCustom.Branchoffice,
tblAssetCustom.Location,
tblAssetCustom.Custom1,
tblAssetCustom.OrderNumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
03-22-2013 06:05 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssetCustom.Serialnumber,
tblAssets.IPAddress,
tblAssetCustom.Branchoffice,
tblAssetCustom.Location,
tblAssetCustom.Custom1,
tblAssetCustom.OrderNumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
03-14-2013 05:17 PM
03-14-2013 05:05 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now