Automatically export assets data

[PoWen_Cheng]

I want Lansweeper to schedule and automatically export computer data on assets into a .csv file every week. The data content includes computer name, cpu model, memory model, and hard disk model. How can I do this? thank you

[Mister_Nobody]

To write file on disk you can use ms sql functions but it is not supported by LS.

[Mister_Nobody]

You can create report and schedule to sent it via email

[PoWen_Cheng]

Can it be automatically exported to the hard drive of lansweeper server?
Because I want other programs to retrieve the data in the .csv.
Do you have an example of a report? 

I tried to write a report, but I don’t know how to add the query HDD model. When querying the memory data, the format is not what I want. The example below should show 8 Gib DDR4 instead of the value 8192. How can I modify my report? What about the content? Thanks

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblADusers.Displayname,
  tblAssets.Processor,
  tblAssets.Memory,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Left Join tblADusers On tblADusers.Userdomain = tblAssets.Userdomain
      And tblADusers.Username = tblAssets.Username
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

[Mister_Nobody]

You can see my old report 

https://community.lansweeper.com/t5/general-discussions/hardware-inventory/td-p/40358