reporting dell service tags

[tallapoosa]

how do you build a report to report the dell service tags found?

[Hemoco]

Create a new report with the report builder, then copy/paste this in the sql field.

[tallapoosa]

how do I turn that into a report.. sorry not very good at sql.. i ran it as a script and it completed successfully..

[Hemoco]

Your report could be based on this one :

SELECT     dbo.tblComputers.Computername, dbo.tblComputerSystemProduct.IdentifyingNumber
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputerSystemProduct ON dbo.tblComputers.Computername = dbo.tblComputerSystemProduct.Computername