Transfer assets to a new/different server

[janick]

The following query can be used to build a report to export the assets in a format that is ready to be imported on a new lansweeper installation.
The export of the report must be in CSV format.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tblAssets.OScode,
  tblAssets.SP,
  tblAssets.Description,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.AssetName,
  tblAssets.FQDN,
  tblAssets.Mac,
  tblAssets.Memory As [Memory (MB)],
  tblAssets.NrProcessors,
  tblAssets.Processor,
  tblState.Statename As State,
  Convert(CHAR(10),tblAssetCustom.PurchaseDate,126) As PurchaseDate,
  Convert(CHAR(10),tblAssetCustom.Warrantydate,126) As Warrantydate,
  Convert(CHAR(10),tblAssetCustom.LastPatched,126) As LastPatched,
  Convert(CHAR(10),tblAssetCustom.LastFullbackup,126) As LastFullbackup,
  Convert(CHAR(10),tblAssetCustom.LastFullimage,126) As LastFullimage,
  tblAssetCustom.OrderNumber,
  tblAssetCustom.Comments,
  tblAssetCustom.Location,
  tblAssetCustom.Building,
  tblAssetCustom.Department,
  tblAssetCustom.Branchoffice,
  tblAssetCustom.BarCode,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Contact,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.Scanserver,
  tblAssetCustom.Custom1,
  tblAssetCustom.Custom2,
  tblAssetCustom.Custom3,
  tblAssetCustom.Custom4,
  tblAssetCustom.Custom5,
  tblAssetCustom.Custom6,
  tblAssetCustom.Custom7,
  tblAssetCustom.Custom8,
  tblAssetCustom.Custom9,
  tblAssetCustom.Custom10,
  tblAssetCustom.Custom11,
  tblAssetCustom.Custom12,
  tblAssetCustom.Custom13,
  tblAssetCustom.Custom14,
  tblAssetCustom.Custom15,
  tblAssetCustom.Custom16,
  tblAssetCustom.Custom17,
  tblAssetCustom.Custom18,
  tblAssetCustom.Custom19,
  tblAssetCustom.Custom20
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID