Hi
This report should give you all the pc names that contain
-pc-change pc in the code below as you will for LT or TB as neccesary
If the Computer names start with -pc- then remove the leading %
If the Computer names end with -pc- then remove the trailing %
the report will give you:
Computer Serial Number Domain OSname Description InstallDate Manufacturer Model PurchaseDate Warrantydate Code:Select Top 1000000 tblComputers.Computer,
tblComputerSystemProduct.IdentifyingNumber As [Serial
Number],
tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description,
Web40OSName.Compimage As icon, tblOperatingsystem.InstallDate,
tblComputersystem.Manufacturer, tblComputersystem.Model,
tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate
From tblComputers Left Outer Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblBIOS On tblComputers.Computername = tblBIOS.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername
Where tblComputers.Computer Like '%-pc-%'
Optionally add this at the end (add a space after the last
') if you would like to further filter on a PC manufacturer (change hp to dell or ibm, fujitsu, etc)
And tblComputersystem.Model Like 'hp%'hope its what your after
ChrisS
