cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
janick
Engaged Sweeper II
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
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now