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 an existing Lansweeper installation to UI.
To export data directly from a Lansweeper installation to Universal Inventory, do the following:
- If you have not already done so, update your Lansweeper installation to the latest release by following the instructions in this knowledge base article. Lansweeper 6.0.100 or higher is required to be able to export to Universal Inventory. You can verify whether you are on the latest Lansweeper release by hitting the Check for Updates now button in the following section of the web console: Configuration\Your Lansweeper License
- 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.
- Stop the Lansweeper Server and web server services on your Lansweeper server, as it is best not to export to Universal Inventory while data is potentially also being written to your Lansweeper database. Keep in mind that stopping the web service will log everyone out of the console. Your web server service is either IIS Express or World Wide Web Publishing Service (IIS).
- Download this archive file that contains LsExport.
- Unzip the file somewhere and then copy its contents to the folder below on your Lansweeper server. Hit Replace when prompted to overwrite some of the files in the existing subfolders.Program Files (x86)\Lansweeper\Tools
- Run LsExport.exe and hit Export To Universal Inventory. The Connect To Lansweeper section of the resulting screen should automatically be filled in with the database connection details of your existing Lansweeper installation.
- 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 example 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.
- Restart the Lansweeper and web server services on your Lansweeper server.
- 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.