One of the biggest challenges facing IT administrators today is to get an accurate picture of their IT environment and in particular the machines, users and software contained within.
Universal Inventory (UI) is a Microsoft tool that consolidates IT infrastructure data collected through various platforms, including Lansweeper. UI is an optional compliment to your Lansweeper installation that allows you to expand on collected information, consolidate asset and user records across multiple sources and enrich data through normalization services. This aggregated data can then be used for a variety of purposes, including software compliance audits. It can also easily be refreshed. No data leaves the Universal Inventory tool or is sent to third parties unless specified by the IT administrator.
LsExport is a tool developed by Lansweeper that exports scanned Lansweeper data to Microsoft Universal Inventory. This article explains how to use LsExport to export data from a Lansweeper SQL Server database to Universal Inventory.
To export data from a Lansweeper SQL Server database to Universal Inventory, do the following:
- Make sure your Lansweeper database is from an up-to-date Lansweeper installation, as Lansweeper 6.0.100 or higher is required to be able to export to Universal Inventory. Lansweeper update instructions can be found in this knowledge base article.
- Make sure you have Universal Inventory installed on a machine. You can download the installer through this page on the Microsoft website.
- Open Universal Inventory.exe.
- Click New Project in the top left corner or use an existing project. When creating a project, an underlying database is also generated to store the project's data. Take note of both your project name and project database name for future reference.Your project database will be called UI_projectname. If your project name contains spaces, these will be replaced by underscores in your database name. If your project is called Lansweeper Data for instance, your project database will be called UI_Lansweeper_Data.
- Download this archive file that contains LsExport.
- Unzip the file into a folder of your choosing.
- Run LsExport.exe and hit Export To Universal Inventory
- Fill in the connection details for your Lansweeper SQL Server database in the Connect To Lansweeper section and hit Connect- Database Type: SQL Server.- Database Server: the SQL Server instance hosting your Lansweeper database.- Authentication Type: the authentication method (Windows or SQL) used to connect to the SQL Server instance hosting your Lansweeper database. Regardless of whether you choose Windows or SQL, the user must at least be a db_owner of your Lansweeper database.- Database Name: your Lansweeper database name, which is lansweeperdb by default.If you only have a .bak file available of your Lansweeper database, you need to restore it into a SQL Server instance first.
- Fill in the information of your UI project database in the Connect To Universal Inventory section and hit Connect- Database Server: the SQL Server instance hosting your UI database.- Authentication Type: the authentication method (Windows or SQL) used to connect to the SQL Server instance hosting your UI database. Regardless of whether you choose Windows or SQL, the user must have the ability to read and write in the UI database as well as execute stored procedures.- Database Name: your UI project database. Your project database will be called UI_projectname. In the screenshot below our project is called Lansweeper Data, therefore our database is UI_Lansweeper_Data.- Data Source ID: for your reference, the display name you'd like to use for the Lansweeper data source.- Site/Tenant: the site name of your Lansweeper data source, which can be used to filter for Lansweeper data in UI.
- Hit Start in the Export section to start the process of transferring Lansweeper data and wait for the export to complete.
- Open your project in Universal Inventory.exe.
- Hit Gather. Your Lansweeper data set should then be listed under Push
- To generate a CIDC file for your Microsoft SAM partner, open your project, hit Export and then Export again.
- To easily view and filter for Lansweeper data, go back to the main menu, hit Verify and then Search. Select Site/Tenant as a filter, submit the site name you used in LsExport.exe and hit Search. This allows you to filter for Lansweeper data. In the example below the site name is Lansweeper Site.