→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rtforbess
Engaged Sweeper
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?
3 REPLIES 3
rtforbess
Engaged Sweeper
I was able to pull it with that.
Thanks
Esben_D
Lansweeper Employee
Lansweeper Employee
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
Lansweeper Employee
Lansweeper Employee
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.