Can you run a report based on the registry scan feature?

[UMTH]

I Have adobe Reg scans on to find out what the serial numbers are on our machines. It works great as you can see below

registry 1

Regkey: HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Adobe Acrobat\8.0\Registration
Valuename: SERIAL
Value: (serial populates here)
Last scanned: 5/19/2009 4:30:48 PM



But I would like to run a report to find all those keys and put them into a list just like this one for MS Products.

http://www.lansweeper.com/forum/yaf_postst1660_Microsoft-product-key-Report.aspx

Is there anyone who knows how to do this? Thanks for the help.

[UMTH]

Found this while looking around the forums

SELECT     dbo.tblComputers.Computername, dbo.tblRegistry.Valuename, dbo.tblRegistry.Value, dbo.tblRegistry.Lastchanged
FROM         dbo.tblRegistry INNER JOIN
                      dbo.tblComputers ON dbo.tblRegistry.Computername = dbo.tblComputers.Computername
WHERE     (dbo.tblRegistry.Valuename = 'Start') 

This works GREAT! of course replace Valuename = (whatever you need it to say)

[UMTH]

I tried this and its not pulling any info. Do you think since the value name is SERIAL that would work instead of Serialnumber?

EDIT: when I tried this sql errored out and said info is incorrect. I know there has to be a way to pull this info...

[neosys]

Maybe something like that ?

SELECT 
  dbo.tblSerialnumber.Computername,
  dbo.tblSerialnumber.ProductKey,
  dbo.tblSerialnumber.Product,
  dbo.tblSerialnumber.Lastchanged
FROM
  dbo.tblSerialnumber
WHERE
  Product LIKE '%Adobe%'