cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
helpdesktrv
Engaged Sweeper II
Hi,
I'd like to export custom fields of computers and other devices in order to filter them via Excel.
Could you please help me?
Thank you in advance best regards
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

5 REPLIES 5
Hemoco
Lansweeper Alumni
For 1000 computers a database size of 1.5 to 3GB is within the expected range. However, you could optimize your cleanup options so that historical data is purged from your database more frequently. This will keep overall size down.

Cleanup options can be found in your Lansweeper configuration console under Scanning Servers\Your Server\Options\Scanning & Cleanup Options. Items of interest are the following:

Delete history from all history tables after
Delete event log entries after
Delete logon information after


Event log information in particular takes up a lot of database space. When you've made changes to your settings, restart the Lansweeper service to immediately apply them.
helpdesktrv
Engaged Sweeper II
We have almost 1000 computers and 1000 devices..
helpdesktrv
Engaged Sweeper II
Hello Lansweeper
thanks a lot for your suggestion.
I've another question for you: our MDF file is almost 2GB, so, can i optimize it in any way? Is there a way?

Thanx again.
Regards.
helpdesktrv wrote:
I've another question for you: our MDF file is almost 2GB, so, can i optimize it in any way? Is there a way?

How many computers are currently in your database?
Hemoco
Lansweeper Alumni
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.