Custom fields info for devices can be found in tblCustDevices within the report builder, custom fields info for computers is stored in tblCompCustom.
Example report for devices:
Select tblCustDevices.DeviceKey, tblCustDevices.Ipaddress, tblCustDevices.Mac,
tblCustDevices.Devicetype, tblCustDevices.State, tblCustDevices.Displayname,
tblCustDevices.Description, tblCustDevices.Location, tblCustDevices.Vendor,
tblCustDevices.Contact, tblCustDevices.Model, tblCustDevices.BarCode,
tblCustDevices.Serialnumber, tblCustDevices.Building,
tblCustDevices.Department, tblCustDevices.Branchoffice,
tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate,
tblCustDevices.Custom1, tblCustDevices.FirstSeen, tblCustDevices.LastSeen,
tblCustDevices.LastSaved
From tblCustDevices
Order By tblCustDevices.Devicetype, tblCustDevices.Displayname
Example report for computers:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate,
tblCompCustom.Location, tblCompCustom.Building, tblCompCustom.Department,
tblCompCustom.Branchoffice, tblCompCustom.State, tblCompCustom.Lastchanged,
tblCompCustom.BarCode, tblCompCustom.Custom1, tblCompCustom.Lastsaved,
tblCompCustom.Firstseen, tblCompCustom.Lastseen
From tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Order By tblComputers.ComputerUnique
To use one of the specified reports, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.