
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2011 01:02 PM
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
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
Labels:
- Labels:
-
Archive
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2011 03:14 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-11-2011 08:45 AM
Hi Admin,
Any help on this please...
Kind Regards,
Moss
Any help on this please...
Kind Regards,
Moss

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2011 11:48 AM
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
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2011 03:47 PM
You can copy the sql of report "Device: IP Address list" and add the fields you need.
