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

Select tblCustDevices.Displayname, tblCustDevices.Serialnumber,
tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate,
tblCustDevices.Custom1, tblCustDevices.Mac
From tblCustDevices
Where tblCustDevices.Displayname Like '%Ruckus%'
Order By tblCustDevices.Displayname