Export to excel

[rtforbess]

When I display assets I see the columns Name, Type, Domain, Last user, OS, Model etc.
When I export to excel I lose the last user column.
Is there somewhere I can edit what is exported?

[rtforbess]

I was able to pull it with that.
Thanks

[Esben_D]

Quick update. After further testing we found that this is related to the database type you are using.

If you are using SQL Compact, the Last User and Order Number will be missing. Which is obviously not expected behavior.

If you are using an SQL Server database, these export works as intended and all fields are present.

For people using SQL Compact, you can use the custom report below for the time being. Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx#post38309

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.Domain,
  tblAssets.Username As [Last User],
  tsysOS.OSname As OS,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssets.Mac,
  tblADComputers.OU,
  tblState.Statename,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Description,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssets.FQDN,
  tblAssetCustom.DNSName,
  tblAssetCustom.LastPatched,
  tblAssetCustom.LastFullbackup,
  tblAssetCustom.LastFullimage,
  tblAssetCustom.Location,
  tblAssetCustom.Building,
  tblAssetCustom.Department,
  tblAssetCustom.Branchoffice,
  tblAssetCustom.Contact,
  tblAssetCustom.Serialnumber,
  tblAssetCustom.OrderNumber,
  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,
  tblAssetCustom.PreventCleanup
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Order By tblAssets.Domain,
  tblAssets.AssetName

[Esben_D]

Strange. I just tested it on my local installation and I'm not missing any data. If you are not yet on the latest version (6.0.150) you could try updating. Update instructions can be found here: https://www.lansweeper.com/kb/118/updating-your-installation.html

The best way to get a good export of specific data you want is by using either the built-in reports or create your own custom report if needed.

Should you need help with a specific report I'd recommend searching though our finished reports or posting in our report question topic in the Report Center.