#Lansweeper license management software#
When exporting the report, rename the file “lansweeper_software_inventory” Lansweeper Installed SoftwareĬopy/Paste the following script in Lansweeper to extract a mapping of installed software per device. Left Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID TblSoftware.softwareVersion As softwareVersion TblSoftwareUni.softwareName As softwareName, TblSoftwareUni.SoftwarePublisher As SoftwarePublisher, Select Distinct Concat(tblSoftwareUni.SoftwarePublisher, '_', tblSoftwareUni.softwareName, '_', tblSoftware.softwareVersion) As SoftwareKey, When exporting the report, rename the file “lansweeper_hardware_inventory”Ĭopy/Paste the following script in Lansweeper to extract the relevant software inventory data. ON tblassets.AssetID = tblLinuxBios.AssetIDĮxport the table data as is, and do not alter the column headers. ON tblassets.AssetID = tblLinuxSystem.AssetID ON tblassets.AssetID = tblCitrixGuest.AssetID ON tblassets.AssetID = tblVmwareGuest.AssetID ON tblassets.AssetID = tblHyperVGuest.AssetID ON tblassets.AssetID = tblComputersystem.AssetID ON tblassets.AssetID = tblOperatingsystem.AssetID ON tblassets.AssetID = tblLinuxProcessors.AssetID ON tblassets.AssetID = tblProcessor.AssetID ON tsysassettypes.AssetType = tblassets.Assettype ON tblassets.AssetID = tblassetcustom.AssetID ON tblSoftware.SoftID = tblassets.AssetID TblComputersystem.SystemType AS SystemType, WHEN tblProcessor.NumberOfLogicalProcessors / tblProcessor.NumberOfCores = 2 TblProcessor.NumberOfCores AS NumberOfCores, Tblassetcustom.Serialnumber AS Serialnumber,ĬOALESCE(tblProcessor.Caption, tblLinuxProcessors.Family) AS ProcessorModel, Tblassetcustom.Manufacturer AS Manufacturer, Lansweeper Hardware InventoryĬopy/Paste the following script in Lansweeper to extract the relevant hardware data. Use the following queries to extract the hardware and software data required for analysis. “lansweeper_hardware_inventory” for the hardware query.“lansweeper_installed_software” for the installed software query.“lansweeper_software_inventory” for the software inventory query.When saving and exporting the reports, please make sure that you use this naming convention: Add the name (Title) as per the naming convention below depending on the query you are going to run.Click on Reports and select Create New Report.In order to do that, you’ll need to follow these simple steps: Once the above requirements are satisfied, you can execute the Licenseware Queries for Lansweeper. Make sure that you have access to the Lansweeper installation.In order to query the DB, you’ll need to satisfy the following requirements: Lansweeper has a SQL DB component that stores the data it collects.