Under the Covers - Querying the XP Embedded Repository
Every considered that, in certain circumstances, it would be useful to query the XP Embedded repository directly rather than using the Target Designer or Component Database Manager?
If you simply want to find out which components contain a particular file (e.g iexplorer.exe) you can use the following query:
SELECT ExtendedProperties.StringValue, ComponentObjects.DisplayName
FROM ExtendedProperties INNER JOIN
ComponentObjects ON ComponentObjects.ComponentID
= ExtendedProperties.OwnerID
WHERE (ExtendedProperties.StringValue LIKE 'iexplore.exe') AND
(ExtendedProperties.ResourceTypeID = 1)
ORDER BY ExtendedProperties.StringValue
This will return about 8 or 10 hotfixes and service pack versions of the Internet Explorer components released over the years.
If however you wish to query for the owning components of files, then I recommend investing in Sean Liming’s toolkit that does a much better job at this, including finding reverse dependencies, owners of registry keys, componentising applications, etc…
- Anonymous
June 18, 2009
PingBack from http://patiocushionsource.info/story.php?id=601