Report that displays only Dell Servers

[ESIT]

I need a report that lists only Dell Servers (no workstations) - asset tags would be a bonus. Can any of your report guru's help out with this task?

Thanks!

[ESIT]

Awesome, exactly what I was looking for!

Thanks much!

[Hemoco]

Here you go:

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Model,
                       dbo.tblComputerSystemProduct.IdentifyingNumber
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername INNER JOIN
                      dbo.tblComputerSystemProduct ON dbo.tblComputers.Computername = dbo.tblComputerSystemProduct.Computername
WHERE     (dbo.tblComputersystem.Manufacturer LIKE 'Dell%') AND (dbo.tblComputersystem.Domainrole <> '1')
ORDER BY dbo.tblComputers.Computername