Custom report

[djolly]

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

[djolly]

Worked great thanks again for the fast reply

[Hemoco]

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

[djolly]

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'.

[Hemoco]

Please try the report below.

Select Top 1000000 tblComputers.Computername, tblComputers.Computer,
tblComputers.Domain, tblSystemEnclosure.SerialNumber,
tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate, tblCompCustom.Custom1,
tblNetwork.MACaddress
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