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
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
