Hi Team

After trying select * from WIn32_Product and finding that it doesn't always return all installed software I am now looking at enumerating the reg key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

I've noticed that there's a variety of sub keys

Can someone please explain the use of key like
{196E77C5-F524-4B50-BD1A-2C21EEE9B8F7}
as opposed to
Microsoft SQL Server 10

Sometimes it seems that some software has both a "{" type entry as well as plain English entry.

MS Office does not have plain english value at all and IE is tricky to pick up.

Finally, I suspect that many people have already done this - is there a UDF for it?

TIA

Mark