Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
moss
Engaged Sweeper III
Hi Lansweeper Admin,

The report "Computer: System configuration overview" is brilliant way to have an overview of the computers scanned. I would like to know is there a way or a report that can give similar details of all the devices added manually.

Example lets say I add couple of apple products and Non IT equipment manually. I would like to run the same report "Computer: System configuration overview" if possible or run a new report that will provide all the details about the devices added, like purchase date, barcode, location etc....and all relevant details of all the devices.

Many Thanks,
Moss
4 REPLIES 4
Hemoco
Lansweeper Alumni
try this

Select Top 1000000 tblCustDevices.Displayname As [Device name],
tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation,
tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Model As
[Device
Model], tblCustDevices.Vendor As [Device Vendor],
tblCustDevices.DeviceKey, tblCustDevices.LastSeen, tblCustDevices.Location,
tblCustDevices.Serialnumber, tblCustDevices.BarCode,
tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate,
tblCustDevices.OrderNumber, tblCustDevices.Building,
tblCustDevices.Department, tblCustDevices.Branchoffice,
tblCustDevices.Custom1, tblCustDevices.Comments, tblCustDevices.Description
From tblCustDevices Inner Join
tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype
Inner Join
web40AllIPLocationsDev On web40AllIPLocationsDev.DeviceKey =
tblCustDevices.DeviceKey
Where tblCustDevices.State = 1
moss
Engaged Sweeper III
Hi Admin,

Any help on this please...

Kind Regards,
Moss
moss
Engaged Sweeper III
Hi,

Being no so good at coding can you help me please..............:) I received your code for the system configuration overview, it works beautifully. I wanted something similar to that which gives me a total information about all the devices inclusive to the current details which it gives when you run the report "Device: IP Address list". I would like in addition to it details like..as below

State:
Type:
IP:
Name:
Model:
Vendor:
Contact:
Location:
Serial:
Barcode:
Purchase:
Warranty:
Order:
Building:
Department:
Branch:
Custom1:
Description:
Comments:

Thanks,
Moss
Hemoco
Lansweeper Alumni
You can copy the sql of report "Device: IP Address list" and add the fields you need.

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now