All Devices Report

[moss]

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

[Hemoco]

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]

Hi Admin,

Any help on this please...

Kind Regards,
Moss

[moss]

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]

You can copy the sql of report "Device: IP Address list" and add the fields you need.