I know that there is manual option to filter data in application and then to export that list for example Assets.
But I would like to have this automatically somehow so the only way is to export somehow data to CSV or some other format? How this can be achieved - I have SQL Compact Edition database and using SQL Compact Toolbox to make SQL queries.
I need this because I want to import Assets and Software data into some other application.
You can create reports from within Lansweeper under the Reports tab. You can set up the automatic exporting or mailing of reports under Configuration\Email Alerts, as further outlined in this article.
We have a tool available for migrating your SQL Compact database and installation to SQL Server, if you'd like to more easily run queries against your database externally. Instructions for migrating can be found here.