Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
UMTH
Engaged Sweeper
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.
3 REPLIES 3
UMTH
Engaged Sweeper
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
Engaged Sweeper
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
Engaged Sweeper II
Maybe something like that ?

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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now