→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

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