licenses

[digipoint]

Hey

We need a report of all the different licenses, all the keys, we have from MS products......
in the report builder i don't find the script


can you give me hint how to code this ....

[digipoint]

thx i can continue building now

[Hemoco]

Something like this

SELECT     dbo.tblComputers.Computername, dbo.tblSerialnumber.Product, dbo.tblSerialnumber.ProductID, dbo.tblSerialnumber.ProductKey
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblSerialnumber ON dbo.tblComputers.Computername = dbo.tblSerialnumber.Computername