Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Hi there,

I would like to run a custom report which returns the serial number, purchase date, warranty date, custom field 1, mac address and station name for all computers beginning with the name "VOC-"

Is this doable?

Thanks in advance
Engaged Sweeper
Worked great thanks again for the fast reply
Lansweeper Alumni
You need a completely different report for this, as device information is stored in different tables. (Lansweeper version 5 will merge computers and devices into a single "asset" category.)

Please try the report below for the information you're after.
Select tblCustDevices.Displayname, tblCustDevices.Serialnumber,
tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate,
tblCustDevices.Custom1, tblCustDevices.Mac
From tblCustDevices
Where tblCustDevices.Displayname Like '%Ruckus%'
Order By tblCustDevices.Displayname
Engaged Sweeper
Worked perfectly. Thank you so much. Could you please now provide me with a similar query but this time searching for Devices rather than Computers.

I would now like to use the the same query but this time searching for Devices with the name 'Ruckus'.
Lansweeper Alumni
Please try the report below.

Select Top 1000000 tblComputers.Computername, tblComputers.Computer,
tblComputers.Domain, tblSystemEnclosure.SerialNumber,
tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate, tblCompCustom.Custom1,
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Where tblComputers.Computer Like 'VOC-%' And tblNetwork.IPEnabled = 1
Order By tblComputers.Computer